How do I randomly sort a list of names?

[JIreland]

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.

 

[Ardus Petus]

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

 

[Martin P]

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%.

 

[Ardus Petus]

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