Data Weeding

M

Maow

I have a large data file (58000 odd lines worth) and need to weed it down to
half the size. Is there any quick way of deleting all odd or all even lines
from the spreadsheet as I need an overall representation of the data, not
just the first or second half of it. Thankyou
 
R

Roger Govier

Hi

One way
Create a helper column with the formula
=MOD(ROW(),2)
Copy down the range of your data by double clicking the fill handle at
the bottom right of the cell.
Then apply a filter Data>Filter>Autofilter and on the new helper column
select either 1 or 0.

If you do want to delete this data, then mark the range of visible data
by selecting the row numbers, right click and select delete.
 
Top