Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank Function
Hi
I am wanting to ranking my bowlers scores. There will be a maximum of thirty bowlers. and the highest score for eacg game will get thirty points and so on down to 1 point. Works ok in the mens as they normally get a full field. My problem is that in the ladies division it needs to be based on the same idea but most times they dont get the thrity bowlers. But still need the highest game to get maximum points. Can someone help me with a solution |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank Function
Suppose you only have 5 bowlers.
How many points would each of these scores get: 200 200 188 182 182 Biff "Andrew C" wrote in message ... Hi I am wanting to ranking my bowlers scores. There will be a maximum of thirty bowlers. and the highest score for eacg game will get thirty points and so on down to 1 point. Works ok in the mens as they normally get a full field. My problem is that in the ladies division it needs to be based on the same idea but most times they dont get the thrity bowlers. But still need the highest game to get maximum points. Can someone help me with a solution |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Rank Function | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |