ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I delete even or odd rows in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/140611-how-do-i-delete-even-odd-rows-worksheet.html)

thanks

how do I delete even or odd rows in a worksheet
 


David Biddulph[_2_]

how do I delete even or odd rows in a worksheet
 
Helper column with =MOD(ROW(),2), then autofilter by that column and delete
as applicable.

[And next time, please ask your question in the body of the message, not in
the subject line. Empty messages will often be rejected or ignored.]
--
David Biddulph

"thanks" wrote in message
...





All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com