Masters Pool - Randomize question

[exalex]

Hello,

I am doing a masters pool with friends where we are each going to get 1 player. There are 86 players in the masters field and 86 people participating in the deal. How can i match the two randomly?

 

[Special-K99]

I dont understand the phrase "86 players in the masters field and 86 in the deal".
Are these the same 86 players or 2 x 86 ?

Random list, no duplicates

A1:A86 List of names
B1:B86 =RAND()
C1:C86 =INDEX(A$1:A$86,MATCH(SMALL(B$1:B$86,ROW()),B$1:B$86,0))

This will produce a list of 86 names in column C in random order without duplicates.
From theat list make your selections.

 

[exalex]

There are two sets, 86 people in the 86 and 86 people selecting. So it will be like the below, I want to match players with friends without duplicates and random. Thanks!

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Players[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Bubba Watson[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Fred Couples[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Tiger woods[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Friends[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]John[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]tim[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]bill[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Just create two lists of 86 players with the formulas as above