## Forum Discussion

# golf scorecard

- Mar 09, 2022
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!

dawesy Ooops! Forgot about that. Changed the formula to allow for up to three strokes over par.

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

- Riny_van_EekelenMar 09, 2022Platinum Contributor
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!

- dawesyMar 09, 2022Brass ContributorHi 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- dawesyMar 13, 2022Brass ContributorHi 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

- dawesyJun 21, 2022Brass ContributorHi 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- Riny_van_EekelenJun 21, 2022Platinum Contributor
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.