# Golf Match Play Calculations

#### PDXGolfGuy

##### New Member
Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have figured out basic calculations for the individual net scores sheet.

First Goal:
Goal is to have a player enter their score for a hole, take into account there handicap and if it should be applied (example, I am 18 HDCP therefore I get a stroke subtracted from my entered score each hole, whereas one of my players is a 2 HDCP and based on the course only gets 2 strokes subtracted on holes 6 and 12) and therefore give a score for them.

Second Goal:
Teams are put together during the 3 day tournament (teams 1 and 2, since it's 2 foursomes of golf its 2v2 or team 1A vs team 2A and team 1B vs team 2B. That said I would like to take into account individual scores from above and then based on teams compare which individual had lowest score per hole (i.e. {Player 1 team 1A scores 4, Player 2 team 1A scores a 3; Player 3 team 2A scores 4, Player 4 team 2A scores 5, therefore since player 2 team 1A scored a 3 their score would 'Win' their team the hole. If the hole is tied I would like a notation of either Halved or tied.

I have a added a link of the sheet 'Team Scores' https://drive.google.com/open?id=0B0Af3Tf2bzsLNWk1N2JaZWJiOEE and the look I am going for...and I am open to any suggestions, feedback, etc....

Thank you,
Excel Newb

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### rpaulson

##### Well-known Member
this formula should work for you First goal.

Enter it in cell C28 Then fill right and fill down for the rest for the players scorecards.

=IF(C\$3<=\$B5,C5-1,C5)

Not sure what you are looking for in second Goal.

hth,

Ross

#### PDXGolfGuy

##### New Member
Ross,

Thank you soo much, this totally works, you are awesome If I wanted to copy sheets for different course and update the course handicap information (Static portion in Grey - different for each course), will the calculations update automatically?

PDXGolfGuy

Replies
3
Views
515
Replies
9
Views
542
Replies
3
Views
438
Replies
13
Views
641
Replies
8
Views
1K

1,147,734
Messages
5,742,861
Members
423,760
Latest member
photogfrog

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back