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



Ken Bowditch wrote:

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

--

Dave Peterson