Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract odd numbered rows from one sheet to put into another?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract odd numbered rows from one sheet to put into another?
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 "missy" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Extract Rows Unique to Two Sheets | Excel Discussion (Misc queries) | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
Insert Rows in Balance Sheet Template | New Users to Excel |