Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I think this does it....
Configuring EXCEL spreadsheet for a men's golf association BLITZ format #2
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I need another formula that take the individual's score on a hole, converts it to a STABLEFORD format (ex: DOUBLE BOGEY = 0 pts; BOGEY = 1 pt; PAR = 2 pts; BIRDIE = 3 pts; EAGLE = 4 pts; DOUBLE EAGLE = 8 pts). So if an individual shoots a "4" on a PAR 4 hole, he would get "2 pts" for his team.
So the formula would have to identify the following(all within the same formula because the 3 or 4 team members could shoot different scores:
(PAR = required total number of strokes for that hole)
- 2 below PAR = 4 pts
- 1 below PAR = 3 pts
EVEN PAR = 2 pts
+1 over PAR = 1 pt
+2 over PAR = 0 pts
EXAMPLE on spreadsheet:
TEAM #1 PAR (4) TM PTS
Player A 4 6
Player B 3 7
Player C 5 1
Player D 6 0
Formula needs to populate the "TM PTS" cells with the STABLEFORD scores established from the PAR cells score
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
Answer accepted by question author
Anonymous
You could use a formula like this for column C, where the scores are given in rows 3 to, let's say, 20, and names are in column A.
=IF(COUNTIF(C3:C20,MIN(C3:C20))=1,INDEX($A3:$A20,MATCH(MIN(C3:C20),C3:C20,False),"")
If two people shoot the same lowest score the cell will remain blank. IF you have more rows (or fewer) adjust the 20 in all places.
You can copy this formula to the other 17 columns to identify the best player.
As for the low net, is that adjusted for handicap, or is it on a straight lowest strokes basis? If you have a column where the net is summed for each player, then the formula above will give the name of the lowest based on that column.
Answer accepted by question author
Anonymous
Either this:
=144-SUM(A2:A4)/2
or
=(144-SUM(A2:A4))/2
depends on what you divide by two - the sum of the team handicap, which is then subtracted from 144, or 144 minus the sum of the team handicap.
Answer accepted by question author
Anonymous
Cell D8 is the rollup for the hole for the 4 team members:
=IF(D4-D$1>=2,0,IF(D4-D$1<=-3,8,D$1-D4+2))+IF(D5-D$1>=2,0,IF(D5-D$1<=-3,8,D$1-D5+2))+IF(D6-D$1>=2,0,IF(D6-D$1<=-3,8,D$1-D6+2))+IF(D7-D$1>=2,0,IF(D7-D$1<=-3,8,D$1-D7+2))
Which is copied to the right for the other 17 holes (E8:U8), and B8 just has
=SUM(D8:U8)
Answer accepted by question author
Anonymous
Here's a file with a working formula and layout:
Answer accepted by question author
Anonymous
If you have different pars on different holes, then you need to have a column for those 18 values.
Let's say that par for the hole 1 is in B2, hole 2 in C2 (and so on across the row) and the first player's scores start in cell B3 and continue across Row 3, second player is in row 4, and so on...
This formula will give the points for the first player on hole 1, and can be copied across to match all 18 holes, and down to match all your players, converting all the scores to points:
=IF(B3-B$2>=2,0,IF(B3-B$2<=-3,8,B$2-B3+2))
56 additional answers
Sort by: Most helpful
-
Anonymous
2017-11-14T16:31:16+00:00 - did a test run on Sunday. things went o.k. for the most part. I found one area that I forgot to take into account that "not all of the player's compete in". That would be the 9/9 FRONT & BACK and 18 OVERALL. Currently I have everyone that plays connected to the outcome of identifying the winners. When actually its only the individuals who pay to participate in those "bets" that should be identified as winner's
The best way I could figure out how to do it was to add 3 columns at the end "9/9"; "18", & "SKINS" and place a "Y" for Yes and a "N" for No (reference to participation). so a formula would need to cover the TEAM Player's names, their hole scores, and probably just the "Y" within the column(s) that they paid to participate (9/9, 18, SKINS) and then link the outcome to the "INDIVIDUAL SKINS" cells and/or the 9/9 LOW NET (OPEN) FRONT and BACK and 18 LOW NET (OPEN) or the 9/9 LOW NET (SENIOR) FRONT and BACK and 18 LOW NET (SENIOR)
- This still has me stumped a little (SKIN HOLES ELIMINATED section):
You stated "Select cell G59 to O59 and on the Home ribbon select Conditional Formatting / New Rule / Use a formula to determine which cells to format And use the Formula =70="" and choose the fill format that you want. Then copy those cells and paste formats onto cells U59:AC59"
I guess since I added more rows your numbers no longer reflect the same as mine, so should it actually read, "select cells I69 to Q69 and on the HOME ribbon select Conditional Formatting / New Rule / Use a formula to determine which cells to format And use the Formula =70="" and choose the fill format that you want. then copy those cells and past formats onto cells W69:AE69. Not sure what the "70" relates to?
- I added a TEAM SCORING box. I've got the scores formula for 1st, 2nd, and 3rd correct. and I have which Team came 1st correct (even though I don't need the "Scored xx" next to the TEAM name). However, when I add the ,2) and the ,3) to the TEAM NAMEs for 2nd and 3rd I get a different formula populate. Could you help with that?