Forumula to calculate the CUT LINE at The Masters Tournament

H

hinsdale1

Board Regular
Joined
Oct 7, 2011
Messages
60
The current cut rule at The Masters Tournament is this:


Following the second round, golfers with the low 50 scores, plus ties, plus any golfer within 10 strokes of the lead, advance to play the final two rounds.

I am looking for a formula which will calculate the cut line score: the score to par for which all players worse will be cut.

For example the cut line score for this year's Masters was +6. Here is a table of the 2017 Masters Leaderboard after 2nd Round:

Code: 
[TABLE="width: 194"]
<tbody>[TR]
[TD]Pos[/TD]
[TD="align: left"]Player[/TD]
[TD="align: left"]Score[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD="align: left"]Sergio Garcia[/TD]
[TD="align: right"]-4[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD="align: left"]Rickie Fowler[/TD]
[TD="align: right"]-4[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD="align: left"]Charley Hoffman[/TD]
[TD="align: right"]-4[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD="align: left"]Thomas Pieters[/TD]
[TD="align: right"]-4[/TD]
[/TR]
[TR]
[TD]T5[/TD]
[TD="align: left"]William McGirt[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD]T6[/TD]
[TD="align: left"]Justin Rose[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]T6[/TD]
[TD="align: left"]Ryan Moore[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]T6[/TD]
[TD="align: left"]Jon Rahm[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]T6[/TD]
[TD="align: left"]Fred Couples[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]T10[/TD]
[TD="align: left"]Jordan Spieth[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]T10[/TD]
[TD="align: left"]Adam Scott[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]T10[/TD]
[TD="align: left"]Phil Mickelson[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]T13[/TD]
[TD="align: left"]Soren Kjeldsen[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]T13[/TD]
[TD="align: left"]Matt Kuchar[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]T13[/TD]
[TD="align: left"]Rory McIlroy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]T16[/TD]
[TD="align: left"]Charl Schwartzel[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]T16[/TD]
[TD="align: left"]Hideki Matsuyama[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]T16[/TD]
[TD="align: left"]Martin Kaymer[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Lee Westwood[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Paul Casey[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Kevin Chappell[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Jimmy Walker[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Jason Dufner[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Brooks Koepka[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Russell Henley[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Bill Haas[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Brian Stuard[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Stewart Hagestad (a)[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Brendan Steele[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Marc Leishman[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T19[/TD]
[TD="align: left"]Ernie Els[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]T32[/TD]
[TD="align: left"]Pat Perez[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]T32[/TD]
[TD="align: left"]Steve Stricker[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]T32[/TD]
[TD="align: left"]Louis Oosthuizen[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Brandt Snedeker[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Justin Thomas[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Matthew Fitzpatrick[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Emiliano Grillo[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Kevin Kisner[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Byeong-Hun An[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Daniel Summerhays[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Adam Hadwin[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Andy Sullivan[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD="align: left"]Bernd Wiesberger[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Jason Day[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Branden Grace[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Francesco Molinari[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Daniel Berger[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]J.B. Holmes[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Ross Fisher[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Curtis Luck (a)[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]James Hahn[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T45[/TD]
[TD="align: left"]Larry Mize[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Danny Willett[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Chris Wood[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Yuta Ikeda[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Shane Lowry[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Billy Hurley[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Jim Furyk[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Zach Johnson[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T54[/TD]
[TD="align: left"]Kevin Na[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Rod Pampling[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Webb Simpson[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Henrik Stenson[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Alexander Noren[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Bubba Watson[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Scott Piercy[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Tommy Fleetwood[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Russell Knox[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T62[/TD]
[TD="align: left"]Rafael Cabrera-Bello[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Hudson Swafford[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Brad Dalke (a)[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Jose Maria Olazabal[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Vijay Singh[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Bernhard Langer[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Patrick Reed[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T71[/TD]
[TD="align: left"]Sean O'Hair[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]T78[/TD]
[TD="align: left"]Ian Woosnam[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]T78[/TD]
[TD="align: left"]Rafael Cabrera-Bello[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]T78[/TD]
[TD="align: left"]Jhonattan Vegas[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]T81[/TD]
[TD="align: left"]Trevor Immelman[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]T82[/TD]
[TD="align: left"]Mike Weir[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]T83[/TD]
[TD="align: left"]Gary Woodland[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]T84[/TD]
[TD="align: left"]Mark O'Meara[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]T84[/TD]
[TD="align: left"]Hideto Tanihara[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]T84[/TD]
[TD="align: left"]Jeunghun Wang[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]T84[/TD]
[TD="align: left"]Si Woo Kim[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]T88[/TD]
[TD="align: left"]Roberto Castro[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]T88[/TD]
[TD="align: left"]Scott Gregory (a)[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]90[/TD]
[TD="align: left"]Tyrrell Hatton[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]91[/TD]
[TD="align: left"]Mackenzie Hughes[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]92[/TD]
[TD="align: left"]Sandy Lyle[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]93[/TD]
[TD="align: left"]Toto Gana (a)[/TD]
[TD="align: right"]17[/TD]
[/TR]
</tbody>[/TABLE]

Any help is greatly appreciated!
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
Maybe...

=MAX(MIN(C2:C94)+10,SMALL(C2:C94,50))

Hope this helps

M.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Question
Copy data from sheet to another sheet with long formula
Replies
5
Views
296
johnnyL
J
F
  • Question
VBA to copy and insert a row below only if a certain criteria is met
Replies
2
Views
63
feni1388
F
S
  • Solved
Golf Skins
Replies
3
Views
312
Fluff
Fluff
M
  • Question
Recursive LAMBDA for progressive SMALL calculations
Replies
1
Views
96
macfuller
M
J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
929
felixstraube
F

Forum statistics

Threads
1,215,223
Messages
6,123,715
Members
449,118
Latest member
MichealRed

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top