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

[Handicapper1]

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

 

[Trevor Shuttleworth]

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

 

[Toppers]

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]

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