function or code?

  • Thread starter Thread starter hal
  • Start date Start date
H

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
 
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
 
Back
Top