+ Reply to Thread
Results 1 to 4 of 4

ranking values

  1. #1
    Registered User
    Join Date
    04-18-2006
    Posts
    4

    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. #2
    Gary Keramidas
    Guest

    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
    > View this thread: http://www.excelforum.com/showthread...hreadid=534006
    >




  3. #3
    Gary Keramidas
    Guest

    Re: ranking values

    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" <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
    > View this thread: http://www.excelforum.com/showthread...hreadid=534006
    >




  4. #4
    Registered User
    Join Date
    04-18-2006
    Posts
    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
    Last edited by bosforus; 04-19-2006 at 02:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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