# Golf League Hcp calculation

1. ## Re: Golf League Hcp calculation

Try:

=AVERAGE(SMALL(IF(COLUMN(B7:AC7)>=LARGE(IF(B7:AC7<>"",COLUMN(B7:AC7)),10),B7:AC7,""),{1,2,3,4,5}))

C+S+E

2. ## Re: Golf League Hcp calculation

I figured out how to do it but I am sure there was an easer way and better way to do this

3. ## Re: Golf League Hcp calculation

=AVERAGE(INDEX(SMALL(INDEX(7:7,AGGREGATE(14,6,COLUMN(B7:AC7)/(B7:AC7<>""),MIN(10,COUNT(B7:AC7)))):AC7,ROW(INDIRECT("1:"&MIN(5,COUNT(B7:AC7))))),))

4. ## Re: Golf League Hcp calculation

Hi again,

I don't want to have to run a macro every time I would like it to calculate on its own

Hmmm . . . not asking much, are we!

Ok, the attached workbook will automatically recalculate the average score any time a value in the League HCP row is changed/added/deleted.

The calculation routine is triggered by the "Workbook_SheetChange" routine, so extra "golfer worksheets" may be added to the workbook and the calculation routine will be triggered when appropriate.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

5. ## Re: Golf League Hcp calculation

Thank you for all your help

Page 2 of 2 First 1 2

There are currently 1 users browsing this thread. (0 members and 1 guests)