HOW DO I DELETE EVEN NUMBERED ROWS, LEAVING THE ODD ROWS?
D Dave Peterson Mar 16, 2008 #2 I'd use a helper column. I'd put this formula in the top row: =mod(row(),2) and drag down the length of your data. Then apply data|filter|autofilter to that column. Show the even rows (value of 0) and delete those visible rows.
I'd use a helper column. I'd put this formula in the top row: =mod(row(),2) and drag down the length of your data. Then apply data|filter|autofilter to that column. Show the even rows (value of 0) and delete those visible rows.
