You don't necessarily need to use a sort. Suppose your list of men are in
A1:A5 and the list of women are in B1:B5. The formula

=OFFSET(A1,RAND()*4,0,1,1)

will return a randomly selected male. The formula

=OFFSET(B1,RAND()*4,0,1,1)

will return a randomly selected female.

In both formulas, change the '4' to the number of rows of names, minus 1.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Paul F." <Paul wrote in message
...
A bowling league consisting of an equal number of men and women would like
to
do a blind draw of two person teams (one male & one female) randomly each
night of play so that the teams members will be different each week and
randomly selected.