ExcelBanter - randomize data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - randomize data (https://www.excelbanter.com/excel-discussion-misc-queries/99663-randomize-data.html)

rmg2828

randomize data

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

tim m

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?

All times are GMT +1. The time now is 10:38 PM.