On Mar 16, 7:57*am, Anthony wrote:
For example, in week one, ten golfers played the
course. *The person with the lowest score would get
100 points, second lowest would get 90 points, etc.
In week two, only six golfers played the course. *The
person with the lowest score would get 60 points, second
would get 50 points, etc. *Worksheet is formatted with
player names in cells A18:A30. *Their finishes on each
course are in cells D18:D30 through Q18:Q30. *If a player
did not play a course, DNP is listed in the cell otherwise
it shows what place they finished.

Suppose you want the points for column Q in R18:R30. Put the
following into R18 and copy down:

=IF(ISNUMBER(Q18),RANK(Q18,$Q$18:$Q$30)*10),"")

Substitute 0 for "" (null string) if you that is what you want for
"DNP" players.