Thread: randomize data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default randomize data

you could insert a column in your sheet and enter the =RAND() function in it
and copy that function down for all of your rows, then sort all of your data
according to the rand column. Then delete the rand column when you are done.

"rmg2828" wrote:

How do I randomize a list of data (not numbers) in Excel - Office 2000
Professional?