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...
As variant
In E3
=RANK(A3,$A$3:$A$9)+COUNTIF($A$3:$A3,A3)-1In F3
=INDEX($C$3:$C$9, E3 )Drag both down
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.
