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...
To fix your golf handicap spreadsheet, use absolute cell references. In the formula for calculating the best 8 scores, use $A$2:$A$13 (assuming player names are in column A), and when averaging, use $B$2:$B$13 for handicaps. This way, when you insert new scores, the formula won't shift, ensuring accurate calculations regardless of varying player participation.