Re: Array formula needed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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$1:D1)
),$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!

In article <430e3252$1_1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"Ann" <annatkins@xxxxxxxxxxxxx> wrote:

> 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
.

Relevant Pages