Thread: Rank Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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