Forum Discussion
alejoalexo
Mar 13, 2023Copper Contributor
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...
- 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)
Riny_van_Eekelen
Platinum Contributor
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)
alejoalexo
Mar 13, 2023Copper Contributor
Thank you so much! funny how simple it was, once again thanks!