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.
|