Thread: randomize a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default randomize a list
I add a helper column filled with formulas (=rand())

Then I sort the entire range by that helper column.

LelandKramer wrote:

what is thhe formula to randomize a list??

thank You
Shalom
Leland

--

Dave Peterson
Reply With QuoteReply With Quote