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

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