Inverse Ranking

M

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.
 
L

Luke M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top