Thread: How do I do a random excel sort or shuffle, in no particular order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How do I do a random excel sort or shuffle, in no particular order
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
--
Gary's Student


"terrih" wrote:

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?
Reply With QuoteReply With Quote