How to Rank Duplicate Values in Excel

[@jameswallace8202]

God Bless You, your simple trick solved a problem i had been struggling to deal with for years

[@ChrisMenardTraining]

Thank you

[@fordmccloud4455]

the ranking without showing the duplicate result rank is another level... thank you for this

[@Robert_512]

Nice solution for tied rank. I'm definitely going to use that one!

[@ChrisMenardTraining]

Thanks, Robert. I had to use it to make a chart work.

[@salauddin2322]

Big help .boss😊

[@ChrisMenardTraining]

Glad to help.

[@khalidjamal971]

Dude it's totally wrong formula. 1200 is both are in rank first then how can u calculate the the one 1200 is 1st dhe other is 1200 is 2nd. Correct this 3rd rank into 2nd then I'll subscribe your channel.