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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with randomly displaying values from a list. 1
In excel can you randomly select lines from another tab to post? 1
random select a percentage from a list 5
Randomly select numbers from a range 14
randomly select a cell from an array 6
Select a random sample 2
Random select entries 2
Data Validation 2

Top