golf handicap formula

[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.

 

[Frank Kabel]

Hi
quite similar to your previous question
for the first row (row 2) try the following array formula (entered
with CTRL+SHIFT+ENTER):
=AVERAGE(INDIRECT("R" & ROW() & "C" & LARGE(IF(ISNUMBER
(B2:W2),COLUMN(B2:W2)),6) & ":R" & ROW() & "C" & LARGE(IF(ISNUMBER
(B2:W2),COLUMN(B2:W2)),2),FALSE))

 

[Aladin Akyurek]

You must have a good reason to start another thread on the same question,
possibly because [1] the formulas provided are unintelligible to you or [2]
they don't calculate what you want. If the latter, you'd be better off
giving a different description (possibly accompanied with some example) than
using the same description as the one in your original thread.

 

[duane]

why not save the old handicap results as values before you put in th
new week's scores