Forum Discussion
Solved
INDEX MATCH + LARGE
Hello! I been looking for a couple of hours for this solution and I came across with lots of people having the same issue as me but their formulas was way complicate for me to understand. I have...
alejoalexo Since you tag your question with Excel for Web, why not look into more modern functions at your disposal?
=SORT(A2:B13,2,-1)
A2:B13 contains the Names and Scores
SORT( -----, 2, -1) sorts the array by the 2nd column (Score) in descending order (i.e -1)
=LET(range,A1:B14,SORT(HSTACK(UNIQUE(TAKE(range,,1)),BYROW(UNIQUE(TAKE(range,,1)),LAMBDA(row,MAX(IF(TAKE(range,,1)=row,TAKE(range,,2)))))),2,-1))An alternative could be this formula.