can Excel randomly sort numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to sort numbers in a random sequence. How can I do that in
Excel or any office application?
 
gasmith said:
I would like to sort numbers in a random sequence. How can I do that in
Excel or any office application?
Click to expand...

Yes. Assuming that your numbers are in column A, insert =Random() in column
B. Drag this function downwads so that you have as many calls to Random as
you have numbers to sort randomly.

Select columns A and B

Select Tools|Sort and sort on column B
The numbers in Column A are now sorted in random order. In fact, so are the
numbers in column B since new random values have been generated.

Best Regards,
Fredrik
 
enter formula =rand() Next to the column of numbers. Fill down the
list.

Now sort using the new column to sort by.

Regards
Bill K
 
You must log in or register to reply here.

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

Randomizing 3
How can I sort a column of numbers generated by excel RAND funct? 5
Random Sort 2
Order numbers from smallest to largest 6
Need help randomly sorting cells 3
How do you randomly generate numbers in Excel 2007? 4
Saving Sort settings 1
Sorting within Rows 7

Back
Top