B
Berty
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?
Column headings something like:
Competitor name
Comp 1
Comp 2
etc
Running average - best scores (max 6 to count)
No of rounds played
Current position
.... and icing on the cake would be to format the cells of the 6 leaders
(e.g. colour highlight)
Attached spreadsheet may help visualise it better.
Many thanks for any help proferred.
Berty
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?
Column headings something like:
Competitor name
Comp 1
Comp 2
etc
Running average - best scores (max 6 to count)
No of rounds played
Current position
.... and icing on the cake would be to format the cells of the 6 leaders
(e.g. colour highlight)
Attached spreadsheet may help visualise it better.
Many thanks for any help proferred.
Berty