does anyone know of an efficient way to rank 10 values and place them in descending order. for example, there are 10 teams in a league and at the end of the season they've accumulated points based on their performance. however, as they are listed now they are not in order from 1st to 10th place. i just want to be able to hit a button (or better yet, maybe there's a formula I could type in a cell) and have them displayed in order from 1st to 10th. any ideas?
in my example, the formula is in l6, tot_Points is a named range M6:M16. m6 is
team 1's points
=RANK(M6,ToT_Points)
just copy down
--
Gary
"bosforus" <[email protected]> wrote in
message news:[email protected]...
>
> does anyone know of an efficient way to rank 10 values and place them in
> descending order. for example, there are 10 teams in a league and at
> the end of the season they've accumulated points based on their
> performance. however, as they are listed now they are not in order
> from 1st to 10th place. i just want to be able to hit a button (or
> better yet, maybe there's a formula I could type in a cell) and have
> them displayed in order from 1st to 10th. any ideas?
>
>
> --
> bosforus
> ------------------------------------------------------------------------
> bosforus's Profile:
> http://www.excelforum.com/member.php...o&userid=33621
> View this thread: http://www.excelforum.com/showthread...hreadid=534006
>
i do have all you are requesing in a golf league score sheet. send me your email
and i can give you more info if you need it
--
Gary
"bosforus" <[email protected]> wrote in
message news:[email protected]...
>
> does anyone know of an efficient way to rank 10 values and place them in
> descending order. for example, there are 10 teams in a league and at
> the end of the season they've accumulated points based on their
> performance. however, as they are listed now they are not in order
> from 1st to 10th place. i just want to be able to hit a button (or
> better yet, maybe there's a formula I could type in a cell) and have
> them displayed in order from 1st to 10th. any ideas?
>
>
> --
> bosforus
> ------------------------------------------------------------------------
> bosforus's Profile:
> http://www.excelforum.com/member.php...o&userid=33621
> View this thread: http://www.excelforum.com/showthread...hreadid=534006
>
here's my email, thanks a ton for the help. keeping in mind that I don't wish to rearrange the order of the scores but to rearrange the names of the teams and in different cells from the originals. kind of like a final showing of the ranking seperate from where the scores are actually kept track.
[email protected]
Last edited by bosforus; 04-19-2006 at 02:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks