Formula to Determine a Golf Skin

[VinceF]

Having trouble, appreciate any assistance.

My dilemma is as follows... (if you're a golfer you'll have a better understanding of what I'm trying to accomplish)

With some prior assistance I was given a formula on how to determine a "skin" but going forward I now need to differentiate a "natural" skin from a skin obtained with a handicap. In our golf league a "birdie" for the hole using a stroke due to the players handicap does not supersede a natural birdie.

For example... Joe's handicap is 7 and the handicap for the par 4 hole is rated at 6 therefore Joe gets a stroke on this particular hole. Joe shoots a 4 on the hole and with his handicap he nets a 3. Meanwhile Sam who's handicap is a 4 also scored a 3 on the hole. Joe and Sam's net 3's would push the skin but do to our league rule Joe's net 3 was with a handicap while Sam's net 3 was a natural birdie therefore since Joe's birdie was with a handicap it doesn't supersede Sam's.

I will have cells populated indicating each players hdcp and the hole hdcp to reference in the formula.

Thanks for you assistance.

VinceF

 

[Eric W]

Building on JoeMo's CF formula, and assuming the score for the hole is in A, and the handicap for the hole is in C, try:

=AND(A1=MIN(A$1:A$20),OR(COUNTIF(A$1:A$20,A1)=1,AND(C1=MINIFS(C$1:C$20,A$1:A$20,A1),COUNTIFS(A$1:A$20,A1,C$1:C$20,MINIFS(C$1:C$20,A$1:A$20,A1))=1)))


If your version of Excel doesn't have MINIFS, try instead as a CF formula:

=AND(A1=MIN(A$1:A$20),OR(COUNTIF(A$1:A$20,A1)=1,AND(C1=MIN(IF(A$1:A$20=A1,C$1:C$20)),COUNTIFS(A$1:A$20,A1,C$1:C$20,MIN(IF(A$1:A$20=A1,C$1:C$20)))=1)))