Try this enhanced sample file, which addresses both your questions. I've
provided 2 sheets depending on whether lower scores are better (eg: golf),
or higher scores are better (eg: almost all games other than golf <g). You
just need to input/maintain the names and scores into cols A and B (Just
clear away the dummy data). The final results will auto-compute in cols H to
M. Cols C to G are helper cols (can be hidden away). See whether the sample
better suits your needs.

http://www.savefile.com/files/4835997
1_Points Ranking Formulas_Cabo_wksht.xls
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Cabo Wabo Jim" wrote in message
...
Max,
I also find that when I randomly enter the player place finish it does not
matter if I put in 1 or 16 it calculates the points in the order I enter
them, the first entry gets 1st place points the second 2nd place and so
on.
If I enter place number 5 first it gets first place points?

"Cabo Wabo Jim" wrote in message
...
Max,
I appreciate it, it seems to work expcept one thing. I may have up to 100
players but only 16 getting points. Is there anywhere I can input the
number
of players as to calculate the bonus in correlation with that number?