Results 1 to 3 of 3

Thread: How to rank...?

  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: How to rank...?

    *I have a worksheet which looks similar to this :

    Name Score
    A 60
    B 80
    C 50
    D 90
    E 70
    F 65
    ... ...


    *On another worksheet, I have these columns :

    Rank Name
    1
    2
    3
    4
    ...


    *They are ranking the persons in terms of their scores.
    *What formulas should I place into the second column (Name) to obtain the names ?
    *Thanks in advance.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Let's assume that your list is in $D$4:$E$9. Then in $G$4:$G9 put the numbers: 1-6

    In cell H4, put this formula:

    =LARGE($E$4:$E$9,$G4)

    Copy down to row 9.

    Then in I4 put this formula:

    INDEX($D$4:$E$9,MATCH(H4,$E$4:$E9,),1)

    Copy down to row 9.

    If you use the relative and absolute references correctly, you can extend each list with little effort.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2006
    Posts
    9
    =RANK(J5,$J$5:$J$10,0)
    =RANK(J6,$J$5:$J$10,0)
    =RANK(J7,$J$5:$J$10,0)
    =RANK(J8,$J$5:$J$10,0)
    =RANK(J9,$J$5:$J$10,0)
    =RANK(J10,$J$5:$J$10,0)


    in one cell enter =rank(

    then hit the function wizard, to get help with this function

Posting Permissions

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