Golf best 2 out of 4 scores

[Guest]

Hi I have a sheet that has 4 players per team.Their scores are recorded in
cells c7,c9,c11,c13.Now i want the 2 best scores to be recorded in another
sheet that i have named results in cells c6,c7.So only the 2 best of the 4
scores will be in the result sheet. Thanks Karl

 

[Guest]

Hi Karl,
If you haven't got any data in cells C8, C10 and C12, then this will do what
you want.
In cell C6 on your results page, paste this formula:
=SMALL(Sheet1!C7:C13,1)
And in cell C7, paste this one:
=SMALL(Sheet1!C7:C13,2)
You'll have to replace the Sheet1 reference to whatever your score sheet is
called.

Hope that helped.
Dave

 

[Guest]

Hi Dave Thanks. I do have data in cells c6,c8,c10,c12 what adjustments will
have to be done to the formula then. Thanks Karl

 

[Biff]

Try this:

=SMALL((Sheet1!C$7,Sheet1!C$9,Sheet1!C$11,Sheet1!C$13),ROWS($1:1))

Copy down as needed.

Biff

 

[Guest]

Hi Biff or Dave when I put this formula into my cell c6 on the results page i
get #name? and no value. I don't know what i did wrong. Thanks Karl

 

[Biff]

Post the *EXACT* formula you tried.

Biff

Hi Biff or Dave when I put this formula into my cell c6 on the results
page i
get #name? and no value. I don't know what i did wrong. Thanks Karl

 

[Guest]

Hi Biff I got it to work after working with it. Thanks Much

 

[Biff]

You're welcome!

Biff

Hi Biff I got it to work after working with it. Thanks Much