Forumula to calculate the CUT LINE at The Masters Tournament

[hinsdale1]

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:

[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!

 

[Marcelo Branco]

Maybe...

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

Hope this helps

M.

 

[hinsdale1]

Maybe...

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

Hope this helps

M.

Thanks Marcelo! Figured it would be more complicated with having to handle ties.. this seems too simple to work but it does. You're a genius!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.