A "sort" problem
 

The formulas is [=int(rand()*(100-1)+1)] in cells a1:e1.
Then cells a2:a6, cell a2=a1, a3=b1, a4=c1 etc...

I would like to sort the results in dec. order in cells a2:a6 after
each recalc.

The problem I have after the sort is a result of "REF#" Can anybody
help?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=471550

Hi,
Sorting A2:A6 won't work. However, the following formulas will work.

In A2, =LARGE($A$1:$E$1,1)
In A3, =LARGE( $A$1:$E$1,2)
In A4, =LARGE( $A$1:$E$1,3)
....
....

If you have too many numbers in A1, B1, ..............say Z1, use the
following variation.
In A2, =LARGE($A$1:$Z$1,row()-1)
and fill-down the formula in A3, A4, .....

Regards,
B. R. Ramachandran

"comotoman" wrote:


The formulas is [=int(rand()*(100-1)+1)] in cells a1:e1.
Then cells a2:a6, cell a2=a1, a3=b1, a4=c1 etc...

I would like to sort the results in dec. order in cells a2:a6 after
each recalc.

The problem I have after the sort is a result of "REF#" Can anybody
help?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=471550