Golf Handicap

October 30, 2017 - by Bill Jelen

How to calculate a Golf Handicap in Excel

Watch Video

How to calculate a Golf Handicap in Excel
You have your recent golf scores in Excel
The handicap is the average of the lowest 10 scores in the last 20 rounds
Getting the last 20 is easy thanks to Excel
Getting the smallest using MIN
But... to get the 2nd smallest through 10th smallest, use SMALL() function.
Slow but understandable: =SMALL(,1)+SMALL(,2)+SMALL(,3)…+SMALL(,10) divided by 10
Easier to enter: Array constant {1;2;3;4;5;6;7;8;9;10} as the second argument of SMALL
This will return all 10 values at once
Send that in to the AVERGE function: =AVERAGE(SMALL(A1:A20,{1;2;3;4;5;6;7;8;9;10}))
My fast way for typing the array constant: Type a 1 in a cell. Ctrl + Drag the fill handle from the 1 down to get 2 through 10.
Point a formula at the ten numbers and press F9, then Ctrl + C to copy

Download File

Download the sample file here: Podcast2165.xlsm