in the first column next to your data write:
copy down.![]()
=MOD(ROW(),10)=2
autofilter and delete all rows with FALSEs
if you do not have header row (or more than 1 header - change 2 into 1 or 3 or ...)
in the first column next to your data write:
copy down.![]()
=MOD(ROW(),10)=2
autofilter and delete all rows with FALSEs
if you do not have header row (or more than 1 header - change 2 into 1 or 3 or ...)
Best Regards,
Kaper
Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks