I want to assign all league points based on a players scoring in a dual match
there will be 12 golfers the best score would recieve 12 points and next 11
and so on in the case of a tie they would split the points. I have developed
the scoring sheet so it totals the score now I would like it to assign points
based on their score. I know I need to set up a table and had one done and
somehow it disappeared.

Here's a small sample file that demonstrates this.

Prize money distribution.xls 15kb

http://cjoint.com/?ilu3OxXl8q

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
I want to assign all league points based on a players scoring in a dual
match
there will be 12 golfers the best score would recieve 12 points and next
11
and so on in the case of a tie they would split the points. I have
developed
the scoring sheet so it totals the score now I would like it to assign
points
based on their score. I know I need to set up a table and had one done
and
somehow it disappeared.