function or code?
 

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

function or code?
 

use the rank function

syntax =Rank(value,range)



On Sep 25, 2:41*pm, hal wrote:
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

function or code?
 

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

On Sep 25, 7:41*pm, hal wrote:
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

function or code?
 

wish i found that earlier.

thanks