G
Golfnut1
Right now my spreadsheet has a calculated handicap base on
the last 5 entries. I would like to add a new column that
will give the old handicap before the latest entry. The
weekly input of scores are in columns B thru W, starting
with row 2. How can I do an average of the 5 scores
previous to the last entry? It has to be able to do the
calculations when someone misses a week. Thank you.
the last 5 entries. I would like to add a new column that
will give the old handicap before the latest entry. The
weekly input of scores are in columns B thru W, starting
with row 2. How can I do an average of the 5 scores
previous to the last entry? It has to be able to do the
calculations when someone misses a week. Thank you.