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

#### mrblister

##### Board Regular
 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!

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### Eric W

##### MrExcel MVP
Try this in C2:

Code:
``=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.

Replies
4
Views
86
Replies
4
Views
55
Replies
2
Views
41
Replies
8
Views
108
Replies
7
Views
321