Random Sort of a Specific List of Numbers

[tthiele]

I have a list of 29 numbers (1-29) that I want to mix up in a random order in an adjacent column. What type of formula can I enter to accomplish that task?

Thanks in advance,

Troy

 

[Ivan F Moala]

On 2002-11-05 00:39, tthiele wrote:
I have a list of 29 numbers (1-29) that I want to mix up in a random order in an adjacent column. What type of formula can I enter to accomplish that task?

Thanks in advance,

Troy

Troy
One way is to put in the cells adjacent to these =RAND(), fill down and just sort on these...