Inverse Ranking

[Marie Bayes]

Hi
Hopefully someone can help. I'm ranking a list of 'scores' inversely but
not quite getting the result I require. There are 12 'teams' they are to be
ranked so that the highest score receives 12 'points' if there is an equal
first place they will both get 12, however, the ranking is giving them 11
each. Here's the formula I'm using
=ROUNDUP(RANK(C31,C$31:C$42,- 1), 0)
Can anyone suggest an amendment so that the joint winners get 12, the next
place would be 10, but if there were two in second place they would both get
10 rather than 9????

Thanks in advance.

 

[Luke M]

Try this:

=COUNT(C$31:C$42)-COUNTIF(C$31:C$42,">"&C31)

 

[Luke M]

Or even simpler (why didn't I think of this first??):

=COUNTIF(C$31:C$42,"<="&C31)

 

[Marie Bayes]

So simple when you think about it!!!! Thank you for doing the thinking.