randomize data

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

randomize a list 1
how can I randomize a set of 496 numbers? 3
mixing up a list 1
Randomizing 3
Randomize rows in Excel? 2
Random Sort 2
How do I randomize a list without repeats 2
Is there a simple way to do a randomizing sort? 1

Top