My employees play on a golf league. I've helped them set up a spreadsheet to
track scores. But they've come up with a situation I'm stuck on.
The names are in column B with columns C through Q used to record the weekly
golf score. They'd like to record a moving average in column W, showing the
last four scores for each player. Some players cannot make it every week, so
the cell remains blank.
Also, some substitutes may not have four outings in yet. So the ideal
formula would have the simple average if fewer than four rounds are recorded
(so I guess it would start with =if(count(c4:Q4)<4,AVERAGE(C4:Q4), ...) or
the last four rounds actually played by the golfer for the regulars (to fill
in the elipse of my formula).
I'd prefer to keep it as a formula if possible. I think I could figure out
some code for this but I'm wondering if we can get it with a formula.
Peace.
EQC