Ranking ' Tie Breakers'

Hello Excel Forum Team!

Looking forward to getting your help with the following:

I have created a ranking and used the "rank" formula to determine which associate is best. The ranking has been placed in column S in the excel file and it depends on the total scorecard value placed in column R. Since there are a lot of repeated values I would like to add 3 "Tie breakers" to it. So, if I have 10 associates showing as number 1 I would determine the best with the following:

* The associate with the highest value in the column " QA Attainment" then if still a tie...
* The associate with the highest value in the column " AHT Attainment" then if still a tie...
* The associate with the highest value in the column " CSAT Attainment"

I am attaching the file as a reference

Thank you so much in advance for your help

Resolved. Thanks!