Hi--how do I scramble a list randomly?

L

lmcshelp

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.
 
P

paul

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
 
Top