How do I randomly select data elements from a table?

  • Thread starter Thread starter Ken Bowditch
  • Start date Start date
K

Ken Bowditch

I have a list of 100 golfers. I wish to randomly select them into pairs for
an upcoming 4 ball competition.
 
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
 
You must log in or register to reply here.

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

Random Pairings with a Caveat 1
Randomly select numbers from a range 14
Random Selection 2
Assign points based on two conditions 1
Selecting values from a single table 1
random select a percentage from a list 5
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Help with randomly displaying values from a list. 1

Back
Top