Hi--how do I scramble a list randomly?
 

Hi--I have made a list in Excel 2003 of words, in one column. I would like
to scramble them randomly periodically. It seems it should be simple, and
yet I can't find a way to do it. Any help appreciated. Thank you.

Hi--how do I scramble a list randomly?
 

use a helper column
fill the column with random numbers=rand()
sort by that column
whenever the sheet recalculates the random numbers will regenerate so you
can sort again and again
--
paul

remove nospam for email addy!



"lmcshelp" wrote:

Hi--I have made a list in Excel 2003 of words, in one column. I would like
to scramble them randomly periodically. It seems it should be simple, and
yet I can't find a way to do it. Any help appreciated. Thank you.