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