can Excel randomly sort numbers

[gasmith]

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

[Fredrik Wahlgren]

"gasmith" <[email protected]> wrote in message
news:[email protected]...
> 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

[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

"gasmith" <[email protected]> wrote in message
news:[email protected]...
>I would like to sort numbers in a random sequence. How can I do that in
> Excel or any office application?