use a helper column.
with uneven numbers 1,3,5,7,9 up to 201 followed by even numbers
2,4,6,8,up to 200
paste your names into a column next to the even numbers
highlight the whole area including the even numbers and sort using the
numbers column.
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=468009