I am running a golf league where the last five scores are averaged for a handicap. The problem arises when members do not attend for one week.
I want to average the last five attended weeks but keep the range consistant for all players which would include some zero weeks.
For example scores of
37,41,39,0,47,42,0,39,0 I would like the to find the average of 39,42,47,39,41 but the range would include the 0's
I want to average the last five attended weeks but keep the range consistant for all players which would include some zero weeks.
For example scores of
37,41,39,0,47,42,0,39,0 I would like the to find the average of 39,42,47,39,41 but the range would include the 0's