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