Sorting a list in Excel 2019

Copper Contributor

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 Excel 2019, so I need to find a workaround.


I managed to sort the values using the LARGE function, however, as there are two similar values, using VLOOKUP gives the same name for the two 92% scores. The name list should look: Emily, John, Mia, James, Jessica, Mark and Richard.


Function in E3: =LARGE($A$2:$A$9;ROW(A1))

Function in F3: =VLOOKUP(LARGE($A$2:$A$9;1);$A$3:$D$9;3;FALSE)


I also can't use VBA, so I need some sort of function combination that is available in Excel 2019.


Képernyőkép 2023-07-28 103130.jpg

6 Replies


As variant


In E3


In F3

=INDEX($C$3:$C$9, E3 )

Drag both down


@Sergei Baklan 


Yes, this works! Thank you!

@hidegandras , you are welcome.

You may combine both in one formula if you don't need to show ranks.

@Sergei Baklan 


I don't know what is going on... So if I give a 98% to Richard the entire order gets messed up.


Képernyőkép 2023-07-28 125118.jpg

Resolved by adding a MATCH function. I am only looking for the top 3, so I just need to match 1, 2 and 3.





Oops, my bad, sorry. You are right, we need to match the rank.

In general



=INDEX($C$3:$C$9, MATCH( SMALL($D$3:$D$9, ROW() - ROW($F$2) ), $D$3:$D$9, 0 ) )