Randomly Sort a Series of Numbers
 

I have a column of numbers (for ex.: 1-100) which I desire to sort randomly.
How would I go about doing this?

I am appreicative of any assistance.

One option:
If your data is in A1:A100, put =rand() in B1 and copy down.
Sort by Column B.

tj

"Shoelaces" wrote:

I have a column of numbers (for ex.: 1-100) which I desire to sort randomly.
How would I go about doing this?

I am appreicative of any assistance.

In an adjoining column, enter this formula:

=RAND()

And *double click* on the "fill handle" to automatically copy it as far down
as there are numbers in the original column.

Now simply select *both *columns and sort on the column containing the
Rand() formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Shoelaces" wrote in message
...
I have a column of numbers (for ex.: 1-100) which I desire to sort randomly.
How would I go about doing this?

I am appreicative of any assistance.

Thank you for your help.