function or code?

[hal]

What would be the best way to look at the value in 6 cells and in
another cell next to it put what its rank is? For example, say you
have the following values in 6 different cells 10, 20, 5, 50, 40, 30
and in another cell next to it you want it to put its rank. For
example, for 10 you'd display the number 5, 20 would be 4, 5 would be
6, and so on. Any links, ideas, or answer would be great.

thanks

 

[muddan madhu]

use the rank function

syntax =Rank(value,range)

 

[a.muppet.man]

Assuming your list of numbers are in A1 to A6, then put this formula
in B1 and copy down the formula for each number (B1 to B6)

=RANK(A1,$A$1:$A$6,0)

Regards,
Muppet Man

 

[hal]

wish i found that earlier.

thanks