Odd Even Sort

[slotcarbob]

This is probably simple, but I will ask it anyways. I have a list of people who are placed in one column, after their position is calculated. There are 7 other columns, including the column for average score, which is the criteria for the standings. There is also a position column, 1,2,3,4 etc, that ranks the participants by place of finish.

Here's what I need. I need to sort by that position column, and divide the participants by odd/even. I can them copy/paste those names to 2 separate spreadsheets. I need to know how to split them odd/even. Thanks so much.

[Portuga]

Hi slotcarbob,

Your description of the problem is a bit confusing.
Can you Zip and attach a sample of your data in the thread?

[daddylonglegs]

Assuming position column is J then try adding another column K with this formula in K2 copied down

=MOD(J2,2)

This will give a zero where the position is even or a 1 when it's odd.

Now selsct all data (including new column) and sort by column K