Random sort function for text

G

Guest

I have a list of about 60 names that I need to randomly compile every day.
Does excel have a function for this?
 
D

David Biddulph

Put =RAND() in an adjacent column. Select the range including both column,
and sort by the random number. Sort again as often as you like, as the
RAND() will recalculate each time.
 

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

What is the function to randomly select a cell, like for lottery? 1
Random Numbers 2
how to sort a column of Randomly selected numbers? 8
random draw from list of names 1
Select from a list 2
random between function 8
I want to generate random times (every couple of hours) for dates 1
Highest alphanumeric 6

Top