Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

putting items of a list in random order

Posted by Bonnie Bell on November 14, 2001 10:51 AM
i am trying to constuct a list of items but it needs to be in random order. how would i go about this? help!

Check out our Excel Resources

Re: putting items of a list in random order

Posted by faster on November 14, 2001 10:54 AM

With your list in column A copy this formula down
column B. Sort by column B

=RAND()


Re: putting items of a list in random order

Posted by Dan on November 14, 2001 10:59 AM
One way you could do it is to add a column next to your list and put this in those cells:

=Rand()

This will put random numbers next to your list. Then you can select both columns and sort in descending or ascending order on the cells with the random numbers. Everytime you do the sort , it should change the order because the numbers change on every new calculation in the sheet.

Try it out and see if that works for you. HTH


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.