How can I sort a column of numbers generated by excel RAND funct?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After generating a column of numbers using the random number generator in
Excel, I tried to sort the column low to high. The sort appears to be
random and additional sorting only yields a random column of numbers. How do
I fix the numbers for normal sort?
 
Every time you sort your numbers they are recalculating.

To sort a column of random numbers you could swith calculation to manual.

Tools|Optiona|calculation|Manual

Mike
 
Teethless wrote on Fri, 27 Jul 2007 07:28:03 -0700:

Tm> =SMALL($A$1:$A$100,ROW())

Tm> copy down

Tm> "Erick K" wrote:

??>> After generating a column of numbers using the random
??>> number generator in Excel, I tried to sort the column low
??>> to high. The sort appears to be random and additional
??>> sorting only yields a random column of numbers. How do I
??>> fix the numbers for normal sort?

Another possibility would be to special paste the column as
value and sort that.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 
Erick K said:
After generating a column of numbers using the random number generator in
Excel, I tried to sort the column low to high. The sort appears to be
random and additional sorting only yields a random column of numbers. How do
I fix the numbers for normal sort?
Click to expand...
 
You would need to convert the functions to values prior to sorting, since
sorting usually forces a recalc.

Bernie
 
Back
Top