How do I do a random excel sort or shuffle, in no particular order

T

terrih

I want to create several teams with different people on each team. I want
there to be no particular order to the way I sort the teams and I want excel
to do this for me. Any suggestions?
 
P

Pauwl

Terrih,

I would create a second column, with the formula =RAND() in each cell.
Then sort all columns chosing the new column as the first to sort by.

regards,

PauwlL
 
G

Gary''s Student

Put you list in column A and in column B enter =RAND() and copy down the
column.

Then sort A and B by B.

This will shuffle column A
 
Top