A | B | C | |
1 | NAME | SCORE | WANT THIS |
2 | Cathy | 75 | Dan |
3 | Bert | 50 | Cathy |
4 | Cathy | 75 | Alan |
5 | Bert | 50 | Bert |
6 | Alan | 50 | |
7 | Dan | 100 |
<tbody>
</tbody>
Hello all. I'm looking for a formula for C2 (copied down). The formula returns a unique distinct list (removes duplicates), in descending order of the person's score.
Notes:
- Column A contains names, which may or may not have multiple entries in the column. The names listed don't follow any order.
- The Score in column B is associated to the name in column A, and is always the same. So for example, Alan's score is always 50 in column B (whenever Alan's name shows up in column A).
- It's possible 2 or more people have the exact same score.
- It's also OK if the returned list is Dan, Cathy, Bert, Alan (as Alan and Bert have the same score)
Thanks!