How do I average 4 of the last 8 golf scores to calculate a handic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I saw a similar question by golf.nut1 that was addressed by biff. In that
case they weere taking 4 out of the last 5 scores. However, I am not clear
on the previous solution. In our league, not everyone plays every week so we
also have some missing scores for some golfers
 
Best bet is to go to the Google Archives and search for Golf Handicap in all
the Excel Groups

Choose Google | Groups | Advanced Groups Search | *Excel* in the Groups and
Golf Handicap in the Search Criteria.

I'm sure you'll find some pointers.

Regards

Trevor
 
Best bet is to go to the Google Archives and search for Golf Handicap in all
the Excel Groups

Choose Google | Groups | Advanced Groups Search | *Excel* in the Groups and
Golf Handicap in the Search Criteria.

I'm sure you'll find some pointers.

Regards

Trevor
 
Biff's reply (to golf.nut1)

Assumptions:

Column A holds players names starting in A2.

Row 1 holds the 18 weekly dates the rounds are played in the range B1:S1

The scores are in the range B2:S2.

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(COUNT(B2:S2)=0,"",IF(COUNT(B2:S2)<5,AVERAGE(B2:S2),AVERAGE(SMALL(S2:INDEX(B2:S2,LARGE(IF(B2:S2<>"",COLUMN(B2:S2)-1),5)),{1,2,3,4}))))

If there are less than 5 scores the average will be for the number of scores
that are entered. If no scores are entered the formula will return blank.

HTH
 
Biff's reply (to golf.nut1)

Assumptions:

Column A holds players names starting in A2.

Row 1 holds the 18 weekly dates the rounds are played in the range B1:S1

The scores are in the range B2:S2.

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(COUNT(B2:S2)=0,"",IF(COUNT(B2:S2)<5,AVERAGE(B2:S2),AVERAGE(SMALL(S2:INDEX(B2:S2,LARGE(IF(B2:S2<>"",COLUMN(B2:S2)-1),5)),{1,2,3,4}))))

If there are less than 5 scores the average will be for the number of scores
that are entered. If no scores are entered the formula will return blank.

HTH
 
For the lowest 4 out of the last 8, replace all references to 5 in the
formula with 8.

Don't forget to array enter the formula! CTRL,SHIFT,ENTER (not just ENTER)

Biff
 
For the lowest 4 out of the last 8, replace all references to 5 in the
formula with 8.

Don't forget to array enter the formula! CTRL,SHIFT,ENTER (not just ENTER)

Biff
 
Back
Top