Forum Discussion
golf scorecard
dawesy You need to incorporate the "strokes received" formula into the overall points calculation. To calculate all in one formula is possible but the formula becomes quite complex. Better to add a row for each player where the points per hole are calculated and then added up in the end. You can alway hide these extra rows if you want.
I took the liberty of changing some formats in your sheet 🙂
Enjoy your golf!
Hi attached is a copy of the scorecard i wish to use as you see there are a number of players and i am not sure how to insert your formula the one you sent me works ok except for someone who doesn't get a shot on a particular hole i would be very appreciative if you could work out to the formula to work on my scorecard
Sincerly hoping Ian
dawesy You need to incorporate the "strokes received" formula into the overall points calculation. To calculate all in one formula is possible but the formula becomes quite complex. Better to add a row for each player where the points per hole are calculated and then added up in the end. You can alway hide these extra rows if you want.
I took the liberty of changing some formats in your sheet 🙂
Enjoy your golf!
- Hi it appears to work thank you could you tell me is it a formula or conditioning formatting which ever could you send me how you work it out if that is possible as i would like to do the same in columns L and V if that can be done easily i am not sure how to set the formatting up
Thanks be much appreciated Ian dawesy I added some conditional formatting to the last three columns. By the way, I moved the points out of column W. Otherwise CF will be a complete mess when you try to format both score and points. See if this works for you.
Hi Riny sorry about the mess i sent hopefully this is better have attached a file of a scorecard if you can see this i have tried to highlite the highest and lowest scores i the following columns ( W which is total score to par ) and ( X which is total points ) hope i explained i ok his im
hanks
Ian
dawesy You just uploaded a bunch of text. Please upload a file like you used to and indicate which cell you want to highlight.
- no luck with conditional formatting. yes highest points or lowest score. Columns w and x have copied a sheet hope you can read it don't know i i downloaded ok
Hole 1 2 3 4 5 6 7 8 9 F/Nine 10 11 12 13 14 15 16 17 18 B/Nine Total Points Deduct
Par 5 4 3 4 3 4 4 3 5 35 3 4 3 4 5 4 4 3 5 35 70 H/Cap
Index 15 6 2 17 4 5 1 12 7 13 18 8 10 9 14 11 16 3 if Stroke
A Grade H/Cap Event
McIntosh Joel 9 - - - 115 9
pts 7 7 6 6 6 7 7 5 8 59 5 6 6 6 8 6 6 5 8 56 115
Williams Adam 10 - - - 116 10
pts 7 7 6 6 6 7 7 5 8 59 5 6 6 7 8 6 6 5 8 57 116
Gibson Glen 11 - - - 117 11
pts 7 7 6 6 6 7 7 5 8 59 5 6 6 7 8 6 7 5 8 58 117
Dawes Scott 11 - - - 117 11
pts 7 7 6 6 6 7 7 5 8 59 5 6 6 7 8 6 7 5 8 58 117
Kirkwood Rob 11 - - - 117 11
pts 7 7 6 6 6 7 7 5 8 59 5 6 6 7 8 6 7 5 8 58 117
Stoker Jason 13 - - - 119 13
pts 7 7 6 6 6 7 7 6 8 60 6 6 6 7 8 6 7 5 8 59 119
Szutowicz Darren 13 - - - 119 13
pts 7 7 6 6 6 7 7 6 8 60 6 6 6 7 8 6 7 5 8 59 119
Withers Elton 15 - - - 121 15
pts 8 7 6 6 6 7 7 6 8 61 6 6 6 7 8 7 7 5 8 60 121
Bate Grant 16 - - - 122 16
pts 8 7 6 6 6 7 7 6 8 61 6 6 6 7 8 7 7 6 8 61 122
Smithers George 16 - - - 122 16
pts 8 7 6 6 6 7 7 6 8 61 6 6 6 7 8 7 7 6 8 61 122
Melkerts Ron 17 - - - 123 17
pts 8 7 6 7 6 7 7 6 8 62 6 6 6 7 8 7 7 6 8 61 123
Gollop Ian 17 - - - 123 17
pts 8 7 6 7 6 7 7 6 8 62 6 6 6 7 8 7 7 6 8 61 123
Smith Stuart 17 - - - 123 17
pts 8 7 6 7 6 7 7 6 8 62 6 6 6 7 8 7 7 6 8 61 123
Rowlan Chris 17 - - - 123 17
pts 8 7 6 7 6 7 7 6 8 62 6 6 6 7 8 7 7 6 8 61 123
Barbour Glen 18 - - - 124 18
pts 8 7 6 7 6 7 7 6 8 62 6 7 6 7 8 7 7 6 8 62 124
Lambert Mark 18 - - - 124 18
pts 8 7 6 7 6 7 7 6 8 62 6 7 6 7 8 7 7 6 8 62 124
Arkwright Joel 18 - - - 124 18
pts 8 7 6 7 6 7 7 6 8 62 6 7 6 7 8 7 7 6 8 62 124
Melkerts Luke 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Christie Scott 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Dawes Ian 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Robinson Scott 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Brigham Daniel 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Little Scott 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
Robinson Greg 19 - - - 125 19
pts 8 7 6 7 6 7 8 6 8 63 6 7 6 7 8 7 7 6 8 62 125
English Jim 20 - - - 126 20
pts 8 7 7 7 6 7 8 6 8 64 6 7 6 7 8 7 7 6 8 62 126
Joannou Warren 20 - - - 126 20
pts 8 7 7 7 6 7 8 6 8 64 6 7 6 7 8 7 7 6 8 62 126
Barton John 20 - - - 126 20
pts 8 7 7 7 6 7 8 6 8 64 6 7 6 7 8 7 7 6 8 62 126
Summerside Trevor 20 - - - 126 20
pts 8 7 7 7 6 7 8 6 8 64 6 7 6 7 8 7 7 6 8 62 126
name - - - - -
pts - - - - - - - - - - - - - - - - - - - - -
name - - - - -
pts - - - - - - - - - - - - - - - - - - - - -
name - - - - -
pts - - - - - - - - - - - - - - - - - - - - - dawesy When you say "the highest number in a column", do you mean best result. I.e. highest points or lowest score.
Exactly which cells should be highlighted? Can you give an example of a sheet you would want to do this on? If you haven't already done so, look into Conditional Formatting.
- Hi there again after what you did for me with the handicap formula which is working great thank you again, i was wondering if it possible to highlite the highest number in a column say points or par score
Regards Ian Dawes - Thanks could not have done it without you Thanks again
Ian dawesy Glad to hear it worked!
- Hi Riny have used the system you sent and very pleased with it i am very grateful for all you have done for me can't thank you enough hopefully i don't do anything silly and ruin all you have done
Again thank you
Ian - Hi just received your reply had a quick look and looks good will continue with the rest when I get time and let you know how I go
Thanks for your input hope i don't mess things
Cheers Ian