Hi,
I have a list of numbers entered in rows.
Each row denotes one measurement of compliance.
For anonymity, I removed the names of 23 team members in the top row and replaced them with numbers from 1 to 23.
I'm struggling with the following: I'd like to set up a leader board and for that I would need to know (at least for the last row in this list) who the top 5 performers are. Performance is the number in the row, e.g. in the attached example sheet, "Mr.19" is the best performer in this last measurement because he's got the highest score (57), with "Mr.22" being second with 40 consecutive submissions.
Please, can you help me with a formula that would identify the top 5 performers, say, in columns Z to AE. There could be a tie in one of the top 5 places, so I added a column for the 6th placed.
Thank you