View Single Post
  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

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.