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