I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?

Thank you,

Gabriela

You didn't mention how many fields you have.

With data starting in A1,

For *even* rows, enter this anywhere and copy down as needed:

=INDEX(A:A,2*ROWS($1:1))

For *odd* rows, enter this anywhere and copy down as needed:

=INDEX(A:A,2*ROWS($1:1)-1)

Post back if you need to copy additional fields across columns.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"GM" wrote in message
...
I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?

Thank you,

Gabriela

"GM" wrote:
I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?

One way ..

Assume data in cols A to D, from row2 down
Enter a label in E1, Enter in E2: x, Input in E3: o
Select E2:E3, fill down to the last row of data
Then just do a Data Filter Autofilter on col E
Filter out "x" from droplist in E1, copy filtered rows & paste elsewhere
Repeat with filter for: "o"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---