I’m trying to get a top 10 list from a data table based on two different criteria.
| Name | Sex | Total |
|---|---|---|
| Taylor | f | 268.2341742 |
| Taylor | f | 252.2535105 |
| Halle | f | 250.7678059 |
| Christian | m | 410.1501907 |
What I want is a list of the top 10 women (or men) unique by total. What I’ve been able to get is a list of the top 10 women, but it includes duplicates, which is what I don’t want.
I’ve been able to get a list of the top 10 women by total, but it includes duplicates.
Here is the formula I’m using:
=INDEX(Results[Name],MATCH(UNIQUE(LARGE(FILTER(Results[SinclairTotal],Results[Sex]="f"),[@Rank])),Results[SinclairTotal],0))
Where Results is the table that includes all of the data and the table to fill in has the following columns:
| Rank | Name | Total |
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 |
Thanks