I do this with a helper column. In the helper column, I enter
=mod(row(),2)
The result is wither 0 or 1. Autofilter the data and delete either 0 or 1
(whatever you want). Keep in mind that when you delete the data, it will
recalculate. Remove the autofilter and the helper column and VIOLA (I know
I spelled it wrong), you're done.
"Too much data - Too little time" <Too much data - Too little
wrote in message
...
How do I select every other row on a large Excel Document?