Forum Discussion
Using average
I keep a golf spread sheet that has all the points of each round. For handicapping purposes, we use the average of the last six scores. Since not every player plays each week, the six scores needed...
I’m looking for one like the samples but not necessarily using dates. Just go to players name, enter that score of that day and get the new average. We use 6 round average also
For the legacy Excel 6-years old answer in in this thread below. For the modern Excel that could be like
=LET( CellsWithData, TOROW($E10:AE10,1), AVERAGE(TAKE(FILTER(CellsWithData, CellsWithData<>0),,-6)) )
