Hello,

I currently have an excell sheet that matches the amount of sales individuals get and i have them ranked by which person has the most sales. However, when somebody has the same amount of sales, the value shows in the ranked column but only the first person listed shows up and duplicates. my current formula is =INDEX($A$36:$A$883,MATCH(G6,$R$36:$R$883,0)). attached is an an example of what i am trying to do, and will be a much easier for one to see then for me to explain. Thank you for any help!

-Andrew

guild.xlsx