How do I randomly sort a list of names?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I randomly sort a list of names? I want to match up 2 list of names
(the same names are in both lists) but the same person cannot be matched to
him/herself.
 
Suppose your names are in column A. Copy them to column C. In D1 enter rand()
and copy down. Sort columns C and D, sorted by column D. If there is a match,
sort again. For 6 or more names, the probability of not having a match is 63%.
 
Back
Top