MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Golf Handicap

October 30, 2017 - by Bill Jelen

Golf Handicap

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

Title Photo: HeungSoon / Pixabay

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.