extract odd numbered rows from one sheet to put into another?

M

missy

Does anyone have any idea on how to extract only the odd numbered rows from
one spreadsheet to put into another. I've tried doing this with if
statements but this leaves blank rows which i do not want.
 
T

Trevor Shuttleworth

You could add a "helper" column and enter the formula: =MOD(ROW(),2)

Drag down or AutoFill to the end of your data

Use AutoFilter to select the rows with a 1 in the helper column.

Select the visible rows, copy and paste into your new sheet.

Delete the helper column in the source and target

Done

Regards

Trevor
 
Top