A
afchris
Being that I am (1) too cheap to fork out $30 for software that doe
this for you, and (2) interested in learning more about Excel, I hav
been trying to create a spreadsheet that will calculate my gol
handicap. The calculation for getting your handicap calls for usin
the handicap differential of your 20 most recent rounds of golf, and o
those 20, averaging the 10 lowest and then multiplying that average b
0.96. I've attached the spreadsheet that I have created and would b
eternally grateful to anyone who can help.
So far, this is what I have: =AVERAGE(N2:N35)*0.96
But I need to filter the Date to the 20 most recent, and then from tha
range take the 10 lowest handicap diffentials.
Thanks
Attachment filename: handicap.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46544
this for you, and (2) interested in learning more about Excel, I hav
been trying to create a spreadsheet that will calculate my gol
handicap. The calculation for getting your handicap calls for usin
the handicap differential of your 20 most recent rounds of golf, and o
those 20, averaging the 10 lowest and then multiplying that average b
0.96. I've attached the spreadsheet that I have created and would b
eternally grateful to anyone who can help.
So far, this is what I have: =AVERAGE(N2:N35)*0.96
But I need to filter the Date to the 20 most recent, and then from tha
range take the 10 lowest handicap diffentials.
Thanks
Attachment filename: handicap.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46544