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.

I presume one person can be matched with only one other person

--
AP

"JIreland" a écrit dans le message de
news: ...
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%.

"JIreland" wrote:

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.

Say A is matched with D. This implies D is matched with A.

"Ardus Petus" a écrit dans le message de news:
...
I presume one person can be matched with only one other person

--
AP

"JIreland" a écrit dans le message de
news: ...
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.