Excel data selection

F

Fred

I have several files with 5-10,000 rows of data. I'd like
an easy way to keep every 5th (or 7th etc) row of data and
delete the rest.

Is there a simple way to do this without manually deleting
the unwanted data?

I'm using Excel 97.
 
D

Dave Peterson

Maybe you could use a helper column with a formula like:

=mod(row(),7)
Drag down

Apply data|filter|autofilter and show the rows you want to keep (even copy them
to a new sheet???)

I'd also convert that formula column to values (copy|pastespecial|values). Just
to make filtering a bit quicker.
 
Top