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