Forum Discussion
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...
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.
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.
- Thank you for your effort but the sheet I had created already accomplished this. Like your own when I make space for a new score by dragging the old cells right it changes the calculation. and ignores the new number input. On your sheet if I put a new score in F6 the sum in F20 will just refer to g6-y6.