How do I randomize a list of data (not numbers) in Excel - Office 2000 Professional?
R rmg2828 Jul 17, 2006 #1 How do I randomize a list of data (not numbers) in Excel - Office 2000 Professional?
T tim m Jul 17, 2006 #2 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.
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.
