Golf best 2 out of 4 scores

=?Utf-8?B?S2FybA==?=
Guest
Posts: n/a

 23rd Oct 2006
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

=?Utf-8?B?RGF2ZQ==?=
Guest
Posts: n/a

 23rd Oct 2006
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

"Karl" wrote:

> 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

=?Utf-8?B?S2FybA==?=
Guest
Posts: n/a

 23rd Oct 2006
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

"Dave" wrote:

> 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
>
>
> "Karl" wrote:
>
> > 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

Biff
Guest
Posts: n/a

 23rd Oct 2006
Try this:

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

Copy down as needed.

Biff

"Karl" <(E-Mail Removed)> wrote in message
news:0D3257DD-E2FA-48F7-A001-(E-Mail Removed)...
> 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
>
> "Dave" wrote:
>
>> 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
>>
>>
>> "Karl" wrote:
>>
>> > 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

=?Utf-8?B?S2FybA==?=
Guest
Posts: n/a

 23rd Oct 2006
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" wrote:

> Try this:
>
> =SMALL((Sheet1!C\$7,Sheet1!C\$9,Sheet1!C\$11,Sheet1!C\$13),ROWS(\$1:1))
>
> Copy down as needed.
>
> Biff
>
> "Karl" <(E-Mail Removed)> wrote in message
> news:0D3257DD-E2FA-48F7-A001-(E-Mail Removed)...
> > 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
> >
> > "Dave" wrote:
> >
> >> 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
> >>
> >>
> >> "Karl" wrote:
> >>
> >> > 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

>
>
>

Biff
Guest
Posts: n/a

 23rd Oct 2006
Post the *EXACT* formula you tried.

Biff

"Karl" <(E-Mail Removed)> wrote in message
news45CA832-634C-4A26-89AB-(E-Mail Removed)...
> 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" wrote:
>
>> Try this:
>>
>> =SMALL((Sheet1!C\$7,Sheet1!C\$9,Sheet1!C\$11,Sheet1!C\$13),ROWS(\$1:1))
>>
>> Copy down as needed.
>>
>> Biff
>>
>> "Karl" <(E-Mail Removed)> wrote in message
>> news:0D3257DD-E2FA-48F7-A001-(E-Mail Removed)...
>> > 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
>> >
>> > "Dave" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> "Karl" wrote:
>> >>
>> >> > 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

>>
>>
>>

=?Utf-8?B?S2FybA==?=
Guest
Posts: n/a

 23rd Oct 2006
Hi Biff I got it to work after working with it. Thanks Much

"Biff" wrote:

> Post the *EXACT* formula you tried.
>
> Biff
>
> "Karl" <(E-Mail Removed)> wrote in message
> news45CA832-634C-4A26-89AB-(E-Mail Removed)...
> > 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" wrote:
> >
> >> Try this:
> >>
> >> =SMALL((Sheet1!C\$7,Sheet1!C\$9,Sheet1!C\$11,Sheet1!C\$13),ROWS(\$1:1))
> >>
> >> Copy down as needed.
> >>
> >> Biff
> >>
> >> "Karl" <(E-Mail Removed)> wrote in message
> >> news:0D3257DD-E2FA-48F7-A001-(E-Mail Removed)...
> >> > 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
> >> >
> >> > "Dave" wrote:
> >> >
> >> >> 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
> >> >>
> >> >>
> >> >> "Karl" wrote:
> >> >>
> >> >> > 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
> >>
> >>
> >>

>
>
>

Biff
Guest
Posts: n/a

 23rd Oct 2006
You're welcome!

Biff

"Karl" <(E-Mail Removed)> wrote in message
news:1309E29D-D335-4FE3-89FB-(E-Mail Removed)...
> Hi Biff I got it to work after working with it. Thanks Much
>
> "Biff" wrote:
>
>> Post the *EXACT* formula you tried.
>>
>> Biff
>>
>> "Karl" <(E-Mail Removed)> wrote in message
>> news45CA832-634C-4A26-89AB-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> Try this:
>> >>
>> >> =SMALL((Sheet1!C\$7,Sheet1!C\$9,Sheet1!C\$11,Sheet1!C\$13),ROWS(\$1:1))
>> >>
>> >> Copy down as needed.
>> >>
>> >> Biff
>> >>
>> >> "Karl" <(E-Mail Removed)> wrote in message
>> >> news:0D3257DD-E2FA-48F7-A001-(E-Mail Removed)...
>> >> > Hi Dave Thanks. I do have data in cells c6,c8,c10,c12 what
>> >> > will
>> >> > have to be done to the formula then. Thanks Karl
>> >> >
>> >> > "Dave" wrote:
>> >> >
>> >> >> 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
>> >> >>
>> >> >>
>> >> >> "Karl" wrote:
>> >> >>
>> >> >> > 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
>> >>
>> >>
>> >>

>>
>>
>>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Golf Analyst Microsoft Excel Worksheet Functions 2 24th Nov 2007 03:25 PM =?Utf-8?B?RGF2aWQgSHVyd2l0eg==?= Microsoft Excel Programming 2 24th Oct 2005 09:37 PM =?Utf-8?B?R29sZiBMZWFndWUgU2NoZWR1bGU=?= Microsoft Excel Worksheet Functions 5 13th May 2005 12:14 AM =?Utf-8?B?S2FybA==?= Microsoft Excel Misc 0 15th Jun 2004 01:36 AM Golf.nut1 Microsoft Excel Worksheet Functions 2 10th May 2004 08:48 PM

Features