Systematically Delete Rows

[lamkoid]

Hey Folks,

I got a really huge time series data set that I would like to reduce by 80%.

The dates are in column A and the values are in column C.

I'd like to keep rows 1, 6, 11,16, ... And delete Rows 2, 3, 4, 5, 7, 8, 9, 10, ...

I'm guessing there's some really simple way to do this that I just don't know about.

[trucker10]

A very good site to do that http://www.ozgrid.com/VBA/row-delete-criteria.htm

[shg]

Here's one way:

Please Login or Register  to view this content.

[martindwilson]

non vba is to put in a spare column row 1
=MOD(ROW()+4,5)>0
drag down
auto filter on true
then delete entire visible rows

[trucker10]

I modify the code from shg

Please Login or Register  to view this content.

[lamkoid]

Hey trucker10,

That worked like a charm.

martindwilson's non vba was what I originally had in mind, but the Macro you and shg put together was a snap.

Thanks all for the great lessons in Excel programing!