Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TAN INVERSE ? | Excel Worksheet Functions | |||
what is the formula for TAN INVERSE ? | Excel Discussion (Misc queries) | |||
What is the Function for Inverse sin | Excel Worksheet Functions | |||
log inverse | Excel Discussion (Misc queries) | |||
Inverse sin | Excel Worksheet Functions |