Inverse Ranking
 

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.
--
Marie Bayes

Inverse Ranking
 

Try this:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Marie Bayes" wrote:

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.
--
Marie Bayes

Inverse Ranking
 

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

Try this:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Marie Bayes" wrote:

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.
--
Marie Bayes

Inverse Ranking
 

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


"Luke M" wrote:

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

Try this:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Marie Bayes" wrote:

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.
--
Marie Bayes