How do I randomize a list of names in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a golf group and we draw for teams. I want to be able to list the
names then have the computer do a random sort of the names.

would I be better in access?

Jonas
 
Helper column =RAND(), select the data range including the original & the
helper column, & sort by the random numbers in the helper column.
 

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 generate team 1
Help with randomly displaying values from a list. 1
Randomly assigning Data 1
How can I randomly sort a column of data using Excel? 2
Random name from a list? 5
Excel. How do I remove 1,000 mailed addresses from list of 2,265? 6
unique name list 10
How do I randomly sort a list of names? 3

Back
Top