can Excel randomly sort numbers
 

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

"gasmith" wrote in message
...
I would like to sort numbers in a random sequence. How can I do that in
Excel or any office application?

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

"gasmith" wrote in message
...
I would like to sort numbers in a random sequence. How can I do that in
Excel or any office application?