Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Position in list (XP-->)

    Sorry Friday afternoon question here.

    I have a tally of results for some tests where I have a list of 100 people, I would like to show where someone comes say =3rd like below:

    <pre>
    Score Position
    100 1
    98 2
    97 =3
    97 =3
    95 4</pre>



    Any ideas?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Position in list (XP-->)

    The RANK function tells you somebody's rank, taking ties into account. Say the scores are in column A, starting with A2. Enter the following formula in B2:
    <code>
    =RANK(A2,$A$2:$A$101)
    </code>
    You can fill down to B101. It doesn't mark ties with an =, however. The following formula in B3 will do that for A3:
    <code>
    =IF(OR(RANK(A3,$A$2:$A$101)=RANK(A2,$A$2:$A$101),R ANK(A3,$A$2:$A$101)=RANK(A4,$A$2:$A$101)),"=","")& RANK(A3,$A$2:$A$101)
    </code>
    but you'll have to adjust it for the first and last cell (B2 and B101) to avoid #N/A errors. See attached demo.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Position in list (XP-->)

    Thank you kind sir
    Jerry

Posting Permissions

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