| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Golf best 2 out of 4 scores
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
Try this:
=SMALL((Sheet1!C$7,Sheet1!C$9,Sheet1!C$11,Sheet1!C $13),ROWS($1:1)) Copy down as needed. Biff "Karl" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
Post the *EXACT* formula you tried.
Biff "Karl" wrote in message ... 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" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
Hi Biff I got it to work after working with it. Thanks Much
"Biff" wrote: Post the *EXACT* formula you tried. Biff "Karl" wrote in message ... 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" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Golf best 2 out of 4 scores
You're welcome!
Biff "Karl" wrote in message ... Hi Biff I got it to work after working with it. Thanks Much "Biff" wrote: Post the *EXACT* formula you tried. Biff "Karl" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
| Averaging Golf Scores | Excel Worksheet Functions | |||
| Summary statistics for a golf scores spreadsheet | Excel Worksheet Functions | |||
| conditional Formatting golf scores | Excel Discussion (Misc queries) | |||
| Golf Handicap Using Last 5 Scores | Excel Worksheet Functions | |||
Linear Mode
