Thread: Position in list (XP-->)

1. 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?

2. 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. Re: Position in list (XP-->)

Thank you kind sir

Posting Permissions

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