Forum Discussion
Dave_Moyse
Jun 27, 2022Copper Contributor
Golf Handicap spreadsheet, fixing cells
I have set up a golf handicap spreadsheet for 12 people in my playing group that calculates the best 8 scores from a list of 12 then averages them out to create a playing handicap. When I insert new...
Dave_Moyse
Jun 27, 2022Copper Contributor
Thanks, I want to always show 12 players and their 20 last scores. This example is quite sophisticated, I don't know how I could use it to suit my own purpose.
OliverScheurich
Jun 27, 2022Gold Contributor
You can try the attached file. It gives an overview of each players last 20 scores and the average of the best 8 scores from the last 20 rounds.