Hello Excel world,
Thanks in advance for the help. I have attached an Excel file ** Duplicates Problem Example 1.xlsx ** to better explain my problem. I am currently tracking the amount of work completed by different employees in week-by-week increments. I then have tables set up to have Excel calculate and find who some of the "Top Performers" are and list, by ranking, both the amount of work they completed and their name.
I am using a "LARGE(" function to find the amount of work completed from the list and an "INDEX(MATCH(" function to match the employee's name to the amount of work they completed.
The issue is when there is more than one person who completed the same amount of work. The "INDEX(MATCH(" function simply finds the first name that matches that amount of work completed and will show his/her name multiple times instead of finding the next employee in the list who completed that amount of work (Such as Employee 15 showing up twice in the "Past 5 Days Top Performer Table").
I would like to use a different function or add something on to this one so that it recognizes when the names are duplicated and Excel will provide the next name in the list that completed that amount of work.
I messed around with another table and some IF( functions but I'm hopeful someone more knowledgeable than me will be able to help.
Thank you!
Bookmarks