sort function

[ExcelNewbie2020]

Gurus,

How to sort the below table using a sort function that will show only the names.
Sort the table by score from high to low and result will be the respective names. many thanks

Name	Score				Result (sorted from high to low)
Name1	100				Name1
Name2	95				Name12
Name3	85				Name2
Name4	90				Name5
Name5	95				Name8
Name6	85				Name4
Name7	90				Name7
Name8	95				Name10
Name9	85				Name3
Name10	90				Name6
Name11	75				Name9
Name12	100				Name11

 

[Fluff]

How about

=INDEX(SORT(A2:B13,2,-1),,1)

 

[ExcelNewbie2020]

How about

=INDEX(SORT(A2:B13,2,-1),,1)

it worx like a charm as usual.. many thanks sir

 

[Fluff]

You're welcome & thanks for the feedback.