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


"Handicapper1" wrote in message
...
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

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

"Handicapper1" wrote:

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

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

"Toppers" wrote in message
...
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

"Handicapper1" wrote:

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