First I have the sales person and the number of sales.
Then in columns D and E, I want to know who are the best salesepeople.
The formula in E2 is
=LARGE($B$2:$B$11,$D2) and filled down.
Then I want to know the names of best salespeople.
The formula in F2 is
=INDEX($A$2:$A$11,MATCH($E2,$B$2:$B$11,0)) filled down.
The problem is that 25 and 15 each show up twice for Bob and Jeff and Sue and Carl. But in column F Bob and Sue show up twice because Match returns for the first match only. I need 25 to list Bob and then Jeff and 15 to list Sue and then Carl.
The way I was looking to do it is to check how many times the the value in E appear. If it appears multiple times, then find which instance of that value the cell is next to and then find that value from the Match of the name. So for 25 with 2 values F4 is by the first 25 in E so it would return Bob, and F5 which is by the second 25 would return Jeff.
Sounds simple, but I have not been able to put it in a working formula. I am trying to have a single formula in F giving the desired results.