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

[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?

 

[Guest]

Create a helper column

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

copy down

 

[Guest]

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

 

[James Silverton]

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

 

[ret415]

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?

 

[Bernie Deitrick]

You would need to convert the functions to values prior to sorting, since
sorting usually forces a recalc.

Bernie