View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default How do I delete alternating rows in excel

gump wrote:
I have over 5,000 rows of data. I only need the odd number rows (1,3,5) and
need to delete the even rows. Is there a faster way then hold CTRL and
clicking on even number rows and then deleting? How can select all the even
number of rows and then delete all?


Insert a column. Put =MOD(ROW(),2) in row 1 and copy down. Sort all of your
data by that column. Delete the appropriate rows. Delete the column.