De-Alphabetizing Information.

[JDFontenot]

Version: 2008
Operating System: Mac OS X 10.3 (Panther)
Processor: intel

I have a one column list in Excel that has been alphabetized. I now need to mix up the information. Is it possible to do this?

 

[jpdphd]

Version: 2008
Operating System: Mac OS X 10.3 (Panther)
Processor: intel

I have a one column list in Excel that has been alphabetized. I now need to mix up the information. Is it possible to do this?

You could create a new column containing random numbers =RAND()
then sort by that column.

jpdphd

 

[JDF]

Great, thank you!