Average of lowest 6 from a range - 1 attachment

  • Thread starter Thread starter Berty
  • Start date Start date
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
 
No help now needed ... found "small" function and have been
able to work out most of the rest !!

Berty
 
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
 
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)
 
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
 
Very droll <G>

--
HTH

Bob

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