Remove 'X" amount of data from column

[wttodd24]

Is there a formula that will remove every 10th cell from a column of 10,000
cells?

 

[Bernard Liengme]

A formula cannot delete/add/copy etc; it can only display a result
In the first cell in column next to the one of interest enter
=--(mod(row(),10)=1)
Copy this down as far as needed
This will give you a series of zeros and ones (0, 1) with every tenth row
having the 1 value
Next we must turn these formulas to values so we can sort: select all the
new cells; use Copy and with them still selected use Edit |Paste Special and
specify values
Sort the two column (the one of interest and the new one) with the new
column as the sort key
Now all the 1's are at the bottom and can be deleted
Then delete the new column
best wishes

 

[Herbert Seidenberg]

Or without a formula or an extra column:
Format the first cell with some pattern or color.
Select the first 10 cells > Copy
Select your 10,000 cells with
SHIFT+double-click lower border
Paste Special > Format
Edit > Find > Option > Format > Choose format from cell
Find All > SHIFT+END > Close
Delete