Excel: Help with if formula based on values

Hi Guys need help with below formula as per image current formula is looking into ranking based on A2 which is fine but if I get duplicate value in column AM like line 5 and 6 I want it to give the same ranking in this case it would be 4 and 4 Thank you[IMG]https://imgur.com/a/WPaTs[/IMG] Image: [IMG]https://imgur.com/a/WPaTs[/IMG]https://imgur.com/a/WPaTs

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 13, 2018.

For more resources for Microsoft Excel