Find Ranking

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

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