I have the following table and resulting formulas:

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.