View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_2_] James Silverton[_2_] is offline
external usenet poster
 
Posts: 115
Default How do I get Random pairings in Excel?

"bchappell" wrote in
message
...
I tried that. The only problems was I ended up with 2 people
with the same
random number. Maybe I did it incorrectly?

Even if you did get two people with the same number, it wouldn't
matter after sorting! Tho' they would appear sequentially in the
sorted list they migh or might not be paired.

b I need to match up people randomly for a tournament. Can
I
b use Excel to do this?

Would assigning a random number to each and then sorting on
the
random numbers work?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not