Randomly Sort a Series of Numbers

[Guest]

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.

 

[Guest]

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

tj

 

[RagDyeR]

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!
==============================================

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.

 

[Guest]

Thank you for your help.