How do you do ranking on microsoft excel?

get ranking
Crazy Jarvis asked:

No Websites please. I would like to know how to do ranking so that it changes with the different players outcome
Example:
Player A Player B Player C Player D
1 2 0 0
3 3 1 2
2 -1 -2 1

Total :6 :4 :minus:1 :3

Rank
1 Player?
2 Player?
3 Player?
4 Player?

Thank you so much for the help! :D
Sorry the players score didnt come out right the 1 number is player a the 2nd player b so on and so forth



Comments (2)    Posted in Homework Help    

Subscribe RSS 2.0 feed. Leave a response, or Trackback from your own site.




2 Responses to 'How do you do ranking on microsoft excel?'

  1. unnga - February 22nd, 2009 at 5:27 am

    Like you said, no website. Just click on the help menu and search for rank function.

  2. expletive_xom - February 25th, 2009 at 2:00 am

    paul,
    how do you have your data setup?

    if its set up this way:
    A1=player a
    B1=player b
    C1=player c
    D1=player d

    column A2 to A4 has player a’s numbers 1,3,2
    columnn B2 to B4 has player b’…..you get the idea

    row 5 is your totals
    A5=6
    b5=4
    c5=-1
    d5=3

    then in row 6 cell A6 use this formula

    =RANK(A5,$A$5:$D$5,0)

    and copy it across

    this will give you the rank.
    as you change the numbers, and the rankings will change automatically

    the formula got 3 parts
    - 1st you define the 1st score cell a5
    - 2nd you define the range of all the players totals (cells a5 to d5 (with $ signs))
    - 3rd is the zero. that says highest number is best…if you have golf scores, then use a ,1 and the lowest number will be best.

    hope that helps.


Leave a Reply