Average of lowest 6 from a range - 1 attachment
No help now needed ... found "small" function and have been
able to work out most of the rest !!
Berty
Berty wrote in
:
Help!
Problem: The top 8 players at my golf club (based on the best 6
scores from a series of competitions) will qualify for further
competition. How do I set up a spreadsheet that will automatically
show a running average score for everyone as the season progresses -
but ignoring zero entries and keeping the maximum number of qualifying
competitions to 6?
|