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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
sheet with multiple tabs 3
Insert Rows Based on values in another worksheet 3
Extracting Data 2
Linking rows 1
Extracting rows from a spreadsheet using values from another shee 1
Combine multiple sheets of data into one worksheet 1
Easily extracting data from one spreadsheet to another 5

Top