Return unique, distinct list in descending order, based on values in another column

[mrblister]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NAME[/TD]
[TD]SCORE[/TD]
[TD]WANT THIS[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cathy[/TD]
[TD]75[/TD]
[TD]Dan[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bert[/TD]
[TD]50[/TD]
[TD]Cathy[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cathy[/TD]
[TD]75[/TD]
[TD]Alan[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Bert[/TD]
[TD]50[/TD]
[TD]Bert[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Alan[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Dan[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!

 

[Eric W]

Try this in C2:

=IFERROR(INDEX($A$2:$A$10,MATCH(LARGE(IF($A$2:$A$10<>"",IF(COUNTIF($C$1:$C1,$A$2:$A$10)=0,$B$2:$B$10)),1),IF($A$2:$A$10<>"",IF(COUNTIF($C$1:$C1,$A$2:$A$10)=0,$B$2:$B$10)),0)),"")

Confirm with Control+Shift+Enter, not just enter.