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
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
Why use an array formula when Excel has such a nice sort feature? Data->Sort
--
Regards,
Dave
"Ann" 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
>
>
>
Why use an array formula when Excel has such a nice sort feature? Data->Sort
--
Regards,
Dave
"Ann" 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
>
>
>
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 <[email protected]>,
"Ann" <[email protected]> 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
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 <[email protected]>,
"Ann" <[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks