Randomly Sort a Series of Numbers

S

Shoelaces

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.
 
T

tjtjjtjt

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

tj
 
R

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.
 
Top