Average of lowest 6 from a range - 1 attachment

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
 
B

Berty

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

Berty
 
G

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
 
B

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)
 
M

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
 
B

Bob Phillips

Very droll <G>

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top