Average of lowest 6 from a range - 1 attachment

[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

 

[Berty]

No help now needed ... found "small" function and have been
able to work out most of the rest !!

Berty

 

[Gord Dibben]

Berty

Betty

If you will be dropping in again please note that attachments are discouraged
and probably won't be opened in any event.

Very rarely that a description will not suffice.

Yours was not attached so nothing to deal with.


Gord Dibben MS Excel MVP

 

[Bob Phillips]

Did you do it all in one hit?

=SUM(SMALL(3:3,{1,2,3,4,5,6}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[MartinW]

Did you do it all in one hit?

Shouldn't that be...
Did you do it all in one stroke?

or better yet...
A whole in one!

Cheers
Martin

 

[Bob Phillips]

Very droll <G>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)