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 Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.