Forum Discussion

alejoalexo's avatar
alejoalexo
Copper Contributor
Mar 13, 2023

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...
  • Riny_van_Eekelen's avatar
    Mar 13, 2023

    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)

     

Resources