Thread: Find Ranking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
 
Posts: 108
Default Find Ranking

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.