How do I randomly select data elements from a table?

K

Ken Bowditch

I have a list of 100 golfers. I wish to randomly select them into pairs for
an upcoming 4 ball competition.
 
D

Dave Peterson

Say your data is in A1:A100

You could put
=rand()
in B1:b100

Sort columns A:B by column B.

Then move A51:A100 to B1:B50
And delete the stuff in B51:B100
 
Top