software

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

quot;JIrelandquot; gt; a écrit dans le message de
news: ...
gt; How do I randomly sort a list of names? I want to match up 2 list of names
gt; (the same names are in both lists) but the same person cannot be matched
gt; to
gt; 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%.

quot;JIrelandquot; wrote:

gt; How do I randomly sort a list of names? I want to match up 2 list of names
gt; (the same names are in both lists) but the same person cannot be matched to
gt; him/herself.

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

quot;Ardus Petusquot; gt; a écrit dans le message de news:
...
gt;I presume one person can be matched with only one other person
gt;
gt; --
gt; AP
gt;
gt; quot;JIrelandquot; gt; a écrit dans le message de
gt; news: ...
gt;gt; How do I randomly sort a list of names? I want to match up 2 list of
gt;gt; names
gt;gt; (the same names are in both lists) but the same person cannot be matched
gt;gt; to
gt;gt; him/herself.
gt;
gt;