Spreadsheet: 810721d1671988793-skins-formula-for-a-golf-game-skins-problem-possible-answers
Sheet: Sheet1

 | Team | Player | Hole  1 | Hole  2 | Hole  3 | Hole  4 | Hole  5 | Hole  6 | Hole  7 | Hole  8 | Hole  9 | Hole  10 | Hole  11 | Hole  12 | Hole  13 | Hole  14 | Hole  15 | Hole  16 | Hole  17 | Hole  18 | Front | Back | Total | Front      6 | Middle 6 | Back      6 | Skins |  | Fluff Formula | [NAME] | Marv Answer1 | Best Answer?
 | A | a | 2 | 9 | 5 | 3 | 6 | 2 | 6 | 4 | 6 | 3 | 5 | 4 | 6 | 3 | 7 | 4 | 5 | 7 |  |  |  |  |  |  | 4 |  |  |  |  |  | Need a formula in AB3 down to AB28
 | A | b | 4 | 5 | 6 | 7 | 3 | 7 | 7 | 6 | 4 | 7 | 5 | 7 | 5 | 6 | 6 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Showing how many skins each player received.
 | K | c | 5 | 4 | 5 | 6 | 3 | 6 | 7 | 4 | 4 | 6 | 6 | 4 | 6 | 4 | 7 | 7 | 6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | I've manually put in the correct answers
 | K | d | 6 | 7 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 4 | 6 |  |  |  |  |  |  | 1
 | Q | e | 4 | 7 | 6 | 5 | 6 | 5 | 5 | 4 | 6 | 5 | 6 | 6 | 7 | 7 | 3 | 4 | 4 | 4 |  |  |  |  |  |  | 1 |  |  |  |  |  | I'd like a formula that doesn't need helper columns.
 | Q | f | 7 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 7 | 6 | 6 | 7 | 6 | 7 | 7 | 6 | 5 | 5
 | J | g | 4 | 6 | 5 | 7 | 7 | 4 | 2 | 5 | 4 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 5 | 7 |  |  |  |  |  |  | 1 |  |  |  |  |  | See Conditional Formatting formula that seems to work, BUT with helper rows 30 and 31
 | J | h | 5 | 6 | 5 | 6 | 7 | 5 | 6 | 6 | 5 | 6 | 7 | 7 | 7 | 7 | 5 | 7 | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | =IF(AND(D$31=1,D3=MIN(D$3:D$28)),TRUE,FALSE)
 | 10 | i | 5 | 5 | 5 | 6 | 4 | 5 | 5 | 7 | 5 | 6 | 6 | 4 | 5 | 4 | 6 | 6 | 5 | 4
 | 10 | J | 4 | 6 | 4 | 5 | 4 | 4 | 4 | 5 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 6 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | In MarvAnswer1  Column it uses a helper row (32) again but I'd like without a helper which Fluff and [NAME] still do!!
 | 9 | k | 5 | 6 | 5 | 5 | 7 | 6 | 4 | 5 | 5 | 5 | 4 | 6 | 4 | 5 | 7 | 6 | 4 | 7
 | 9 | l | 4 | 4 | 5 | 6 | 4 | 6 | 4 | 6 | 5 | 5 | 5 | 4 | 5 | 6 | 5 | 4 | 7 | 6
 | 8 | m | 5 | 4 | 4 | 6 | 6 | 6 | 4 | 5 | 5 | 6 | 3 | 6 | 5 | 4 | 4 | 3 | 5 | 5 |  |  |  |  |  |  | 2 |  |  |  |  |  | To test all possible solutions change some scores in the sheet and see what happens.
 | 8 | n | 4 | 4 | 6 | 5 | 4 | 6 | 7 | 7 | 4 | 6 | 5 | 7 | 4 | 5 | 5 | 7 | 4 | 4
 | 7 | o | 4 | 6 | 7 | 5 | 6 | 7 | 7 | 5 | 7 | 5 | 5 | 5 | 7 | 6 | 7 | 6 | 6 | 5
 | 7 | p | 5 | 5 | 5 | 4 | 4 | 5 | 7 | 7 | 7 | 6 | 4 | 6 | 7 | 6 | 4 | 7 | 7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | I keep going back to the CF formula and use it for an answer.
 | 6 | q | 7 | 5 | 7 | 6 | 6 | 4 | 5 | 7 | 4 | 5 | 4 | 7 | 4 | 7 | 6 | 7 | 6 | 5
 | 6 | r | 4 | 4 | 7 | 5 | 4 | 6 | 4 | 5 | 4 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 6 | 5
 | 5 | s | 4 | 6 | 6 | 7 | 4 | 4 | 4 | 4 | 5 | 7 | 5 | 3 | 4 | 5 | 4 | 7 | 6 | 4
 | 5 | t | 5 | 6 | 7 | 6 | 5 | 7 | 5 | 6 | 5 | 6 | 5 | 4 | 4 | 4 | 6 | 4 | 4 | 6
 | 4 | u | 3 | 5 | 5 | 7 | 6 | 7 | 4 | 6 | 5 | 5 | 6 | 5 | 4 | 4 | 4 | 5 | 5 | 3 |  |  |  |  |  |  | 1
 | 4 | v | 6 | 4 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 6 | 4 | 5 | 7 | 7 | 4 | 4 | 5 | 6
 | 3 | w | 5 | 5 | 6 | 6 | 7 | 7 | 6 | 7 | 4 | 5 | 4 | 5 | 7 | 7 | 7 | 5 | 4 | 4
 | 3 | x | 6 | 5 | 5 | 6 | 4 | 6 | 5 | 6 | 5 | 5 | 6 | 4 | 6 | 4 | 4 | 5 | 7 | 6
 | 2 | y | 6 | 6 | 4 | 4 | 6 | 7 | 7 | 7 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 7 | 5 | 4
 | 2 | z | 7 | 7 | 5 | 5 | 4 | 4 | 4 | 6 | 5 | 5 | 4 | 6 | 5 | 7 | 6 | 7 | 6 | 5
 |  | Min
 |  | Min Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | << Total Skins
 |  | Player Skin #