Golf best 2 out of 4 scores

K

Karl

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
 
D

Dave

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
 
K

Karl

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
 
B

Biff

Try this:

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

Copy down as needed.

Biff
 
K

Karl

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
 
B

Biff

Post the *EXACT* formula you tried.

Biff

Karl said:
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
Click to expand...
 
Top