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

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?

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

Create a helper column

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

copy down


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

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

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

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

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

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

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

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

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

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

Bernie


"ret415" wrote in message
...


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