View Single Post
Old 2006-04-27, 11:33 AM   #4
Simon
That which does not kill us, will try, try again.
 
Simon's Avatar
 
Join Date: Aug 2003
Location: Conch Republic
Posts: 5,150
Send a message via ICQ to Simon Send a message via AIM to Simon Send a message via Yahoo to Simon
One more nice thing about doing it that way...

The RAND function in Excel will give you a new sort each time you ask for it.

Insert the function, fill down, select the area for sorting and sort. Now look at the new list. Don't like the 'randomness' enough yet? If you haven't deselected the sorted area, just choose "Sort..." again and you get a fresh reordering. Repeat until you like your list.
__________________
"If you're happy and you know it, think again." -- Guru Pitka
Simon is offline   Reply With Quote