sorting

[ENEMALI]

i have ranked some students from 1st to 100th
i want to sort them base on even and odd ranks.
anybody with any help
thanks.

 

[savino714]

you would have to use conditional formating go to the bottom new rules and u should be able to select ur values.

 

[Ruddles]

I'm not sure what you mean. Do you mean you want 1, 3, 5, 7, 9... down to 99 at the top of the list, then 2, 4, 6, 8... down to 100 in the bottom half of the list?

If not, can you post a sample of your worksheet and show us what you want it to look like after the sort?

 

[ENEMALI]

sorry for the late reply savino and ruddles i later gave up using excel but do it manually but it is time consuming and boring.
the school semester is ending and i will like to do it again with excel that is the sorting should look just as ruddles described (1,3,5,7,9,11..............)
(2,4,6,8,10,12...........)

thanks savino,ruddles and anyone viewing this thread