Golf handicap using 4 of last 5 scores

[Golfnut1]

I would like to set up a Excel spreadsheet for golf handicaps where it
will use
the 4 lowest scores of the last 5 entries. It must be able to work
even if
there are missed entries (someone didn't show up/blanks ignored). I
would
like it to work if there are only three scores used at the beginning of
the
season, but when there are 5 or more scores, use only the 4 lowest
scores out of the last 5. I want it to average these scores. The
scores would start in column d. The following is an example of scores
with an underscore being a blank:
Golfer 1 45,50,42,43,46,37,45,45,46,44
Golfer 2 41,43,42,_,41,_,_,47,42,39
Golfer 3 44,43,45,54,_,45,43,40,42,_
Our season is 18 weeks long, but I don't think that should matter with
this
formula. Can you help me with this problem? Thank you.

 

[wjohnson]

To Track the 4 lowest scores for each golfer - I would insert 4 column
after their name and use the "Small" function, (4 times):Column
B,C,D,E
In Column B: =SMALL(F11,1) this gives you the "lowest"
In Column C: =SMALL(F11,2) this gives the "2nd lowest"
Just replace F11 as required for the 16 weeks, then replace "1" wit
2,3,4 in the different columns. Any non-entries "blanks" shoul
automatically be ignored by the "Small" function

 

[Biff]

See reply in .Misc

Biff