Array formula needed

[Ann]

Hi,

I have a list of team names and scores, how can I use an array formula to
sort the scores descending by team name?
I have heard this is doable but am struggling so far

Any help much appreciated

Thanks

Ann

 

[Guest]

Why use an array formula when Excel has such a nice sort feature? Data->Sort

 

[Domenic]

Assuming that Column A contains the team name, and Column B contains the
score, try the following...

D1, copied down and over to Column E:

=INDEX(A$1:A$10,MATCH(LARGE($B$1:$B$10-ROW($B$1:$B$10)/10^10,ROWS(D$11)
),$B$1:$B$10-ROW($B$1:$B$10)/10^10,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the
ranges accordingly.

Hope this helps!