| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Post the *EXACT* formula you tried.
Biff "Karl" <(E-Mail Removed)> wrote in message news  45CA832-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 >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 > news 45CA832-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 > >> > >> > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 >> news 45CA832-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 >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel golf scores, how do I add the scores for all par 3's etc | Golf Analyst | Microsoft Excel Worksheet Functions | 2 | 24th Nov 2007 03:25 PM |
| how to pick the lowest 10 golf scores | =?Utf-8?B?RGF2aWQgSHVyd2l0eg==?= | Microsoft Excel Programming | 2 | 24th Oct 2005 09:37 PM |
| Golf Handicap Using Last 5 Scores | =?Utf-8?B?R29sZiBMZWFndWUgU2NoZWR1bGU=?= | Microsoft Excel Worksheet Functions | 5 | 13th May 2005 12:14 AM |
| Golf Scores | =?Utf-8?B?S2FybA==?= | Microsoft Excel Misc | 0 | 15th Jun 2004 01:36 AM |
| golf scores | Golf.nut1 | Microsoft Excel Worksheet Functions | 2 | 10th May 2004 08:48 PM |
