Find Ranking
Excellent!
Thanks!
"Niek Otten" wrote:
<743,740 is the 5th ranked number
I don't think so. It's the 4th.
What makes you think it is 5th?
If I'm right, this is the formula:
=INDEX(B10:B19,MATCH(D1,A10:A19,-1))
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Rod" wrote in message
...
Hello,
I have A10 to B19:
988,596 1
874,126 2
805,272 3
753,053 4
743,739 5
734,685 6
665,335 7
643,460 8
640,664 9
633,636 10
If the number 743,740 is calcualated in another cell, say D10, I would
like
to return 5 because 743,740 is the 5th ranked number.
Thanks.
|