How do I copy/paste odd or even rows from Exel?

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" <GM@discussions.microsoft.com> wrote in message
news:C7E59E9D-EB93-45D9-8979-B136479CEE43@microsoft.com...
>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
---