List numbering

[akay47]

This is probably simple!

I have a list of teams and scores I'd like to order in a league table. That's easy, but I am trying to number them by their rank depending on their score, and where they are equal they get the same rank and then it skips to the next number for the next team with a lower score. eg

1. Team G - Score 95
1. Team C - Score 95
1. Team F - Score 95
4. Team H - Score 90
5. Team E - Score 86
6. Team D - Score 83
6. Team A - Score 83
8. Team B - Score 80

So in the above Teams G, C and F all have the same score and are ranked #1, the next highest scoring team is team H who are then ranked #4 and so on..

any help appreciated.

Akay47

 

[oldchippy]

Hi @akay47,

Welcome to the forum, take a look at this previous question, it may help

http://chandoo.org/forum/threads/rank-changing-the-sequens-of-duplicate-values.24731/#post-148676

 

[Khalid NGO]

Hi @akay47 welcome to the forum.

I have supposed your data range is C2:C9.

Use the simple RANK formula:

=RANK(C2,$C$2:$C$9)

or this, if you want sequential ranks without duplicate:
=RANK(C2,$C$2:$C$9,0)+COUNTIF($C$2:$C2,C2)-1

Regards,

 

[Syedali]

Hi @akay47 ,

try this =RANK(C2,$C$2:$C$9,0)

 

[akay47]

Brill, thanks for your speedy and most helpful replies!