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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Handicapper1 - 20 Aug 2006 14:05 GMT

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

Reply to this Message

Trevor Shuttleworth - 20 Aug 2006 14:21 GMT

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

>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

Reply to this Message

Toppers - 20 Aug 2006 14:32 GMT

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

> 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

Reply to this Message

Biff - 20 Aug 2006 19:43 GMT

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

> Biff's reply (to golf.nut1)
>
[quoted text clipped - 23 lines]
>> so we
>> also have some missing scores for some golfers

Reply to this Message