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 wrote in
:

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?

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


On Sun, 27 May 2007 18:52:33 -0500, Berty wrote:

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

Berty






Berty wrote in
:

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?

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)

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

Berty






Berty wrote in
:

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?

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)

"MartinW" wrote in message
...
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