Need to search golf scores and highlight the lowest score for each hole if it is unique

[alagramj]

I need to search a list of golf scores for each hole and count and highlight in yellow the lowest score for each hole but only if it is unique.

I will also need a count of those unique scores.

These lowest, unique scores and commonly referred to as SKINS in the golfing world.

[MarvinP]

Hi alagramJ and welcome to the forum,

You need a Min() formula and a CountIf() formula. See the attached:
Calculate Skins Answer.xlsx

[alagramj]

Thanks for helping out. I incorporated your formula suggestions and the results are looking much better.

Getting further into the logic of the SKINS requirements I see we have 3 remaining issues to deal with.
1. highlighting the skins, 2. a total skin number for each player and 3. bypassing the scores for players who said "no" to the skins game.

I will attach my latest version.

Thanks again for your help, it is very much appreciated!

[JeteMc]

As to #1 the following formula could be used as a conditional formatting rule: =AND(D$7="yes",D8=D$4)
As to #2 populate D4:H4 using: =MINIFS(D8:D17,$B8:$B17,"y")
Note that MINIFS is supported by the 2019 and 365 versions. Please find the version you are using by selecting the File tab and then Account.
If you have the 2016 or earlier version you will need to use the following array entered formula** instead (see cells D27:H27): =MIN(IF($B8:$B17="y",D8:D17))
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
As to #3 populate cells D20:H20 using: =IFERROR(INDEX($C8:$C17,AGGREGATE(15,6,(ROW($C8:$C17)-ROW($C7))/(D7="yes")/(D8:D17=D4),1)),"")
and then populate cells I8:I17 using: =COUNTIFS(D$20:H$20,C8)
Let us know if you have any questions.