# ranking values

1. ## ranking values

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?

2. ## Re: ranking values

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" <bosforus.26hskm_1145418033.6728@excelforum-nospam.com> wrote in
message news:bosforus.26hskm_1145418033.6728@excelforum-nospam.com...
>
> 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
>

3. ## Re: ranking values

i do have all you are requesing in a golf league score sheet. send me your email

--

Gary

"bosforus" <bosforus.26hskm_1145418033.6728@excelforum-nospam.com> wrote in
message news:bosforus.26hskm_1145418033.6728@excelforum-nospam.com...
>
> 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
>

4. ## here you go

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.
smswitzer@hotmail.com

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1