can Excel randomly sort numbers

G

gasmith

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

Fredrik Wahlgren

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
 
B

Bill Kuunders

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
 
Top