Forum Discussion
Sorting a list in Excel 2019
I have a list of names and a score for each person. I need to sort this list in descending order, name of the highest score on the top, lowest on the bottom. SORT function is not available in Exc...
hidegandras , you are welcome.
You may combine both in one formula if you don't need to show ranks.
I don't know what is going on... So if I give a 98% to Richard the entire order gets messed up.
Resolved by adding a MATCH function. I am only looking for the top 3, so I just need to match 1, 2 and 3.
=INDEX($C$3:$C$9;MATCH(1;$E$3:$E$9;0))Oops, my bad, sorry. You are right, we need to match the rank.
In general
with
=INDEX($C$3:$C$9, MATCH( SMALL($D$3:$D$9, ROW() - ROW($F$2) ), $D$3:$D$9, 0 ) )