Spreadsheet: 214600d1360989841-highlighting-lowest-score-w-o-duplicates-highlighting-and-counting-player-skins-skins
Sheet: Score Card

 |  |  |  |  |  |  |  |  | GROSS SCORES
 |  |  |  |  |  |  |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Name | Player HCP | Gross |  |  | Net |  |  |  | Par | 4 | 4 | 5 | 4 | 3 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 4 | 4 | 4 |  | NET SCORES
 |  | F9 | B9 | 18 Tot | F9 | B9 | 18 Tot |  | HCP | 11 | 6 | 8 | 18 | 4 | 2 | 14 | 10 | 16 | 9 | 15 | 5 | 7 | 13 | 1 | 17 | 3 | 12 |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
[NAME] | 0 | 50 | 45 | 95 | 50 | 45 | 95 |  |  | 3 | 7 | 6 | 3 | 5 | 8 | 6 | 7 | 5 | 6 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 |  |  | 3 | 7 | 6 | 3 | 5 | 8 | 6 | 7 | 5 | 6 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5
Fred | 0 | 36 | 39 | 75 | 36 | 39 | 75 |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 6 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 6 | 4 | 4 | 4
[NAME] | 0 | 35 | 37 | 72 | 35 | 37 | 72 |  |  | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] | 0 | 43 | 43 | 86 | 43 | 43 | 86 |  |  | 5 | 4 | 5 | 4 | 4 | 4 | 6 | 6 | 5 | 6 | 5 | 4 | 5 | 5 | 6 | 5 | 3 | 4 |  |  | 5 | 4 | 5 | 4 | 4 | 4 | 6 | 6 | 5 | 6 | 5 | 4 | 5 | 5 | 6 | 5 | 3 | 4
[NAME] | 0 | 36 | 36 | 72 | 36 | 36 | 72 |  |  | 4 | 4 | 5 | 4 | 3 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 4 | 4 | 4 |  |  | 4 | 4 | 5 | 4 | 3 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 4 | 4 | 4
[NAME] | 0 | 43 | 43 | 86 | 43 | 43 | 86 |  |  | 5 | 4 | 5 | 4 | 4 | 4 | 6 | 6 | 5 | 6 | 5 | 4 | 5 | 5 | 6 | 5 | 3 | 4 |  |  | 5 | 4 | 5 | 4 | 4 | 4 | 6 | 6 | 5 | 6 | 5 | 4 | 5 | 5 | 6 | 5 | 3 | 4
 |  |  |  |  |  |  |  |  |  | Skin |  |  | Skin |  |  |  | Skin |  |  | Skin |  |  | Skin | Skin |  |  |  |  |  | Skin |  |  | Skin |  |  |  | Skin |  |  | Skin |  |  | Skin | Skin
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] | [NAME] |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | GROSS SCORES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET SCORES
 |  |  |  |  |  |  |  |  | Eagle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Eagle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | [NAME] | 1 | 0 | 2 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 |  | [NAME] | 1 | 0 | 2 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0
 |  |  |  |  |  |  |  |  | Par | 3 | 5 | 3 | 5 | 2 | 5 | 1 | 1 | 3 | 3 | 1 | 5 | 3 | 1 | 2 | 3 | 3 | 5 |  | Par | 3 | 5 | 3 | 5 | 2 | 5 | 1 | 1 | 3 | 3 | 1 | 5 | 3 | 1 | 2 | 3 | 3 | 5
 |  |  |  |  |  |  |  |  | Bogy | 2 | 0 | 1 | 0 | 3 | 0 | 3 | 2 | 3 | 3 | 2 | 1 | 3 | 3 | 3 | 3 | 1 | 1 |  | Bogy | 2 | 0 | 1 | 0 | 3 | 0 | 3 | 2 | 3 | 3 | 2 | 1 | 3 | 3 | 3 | 3 | 1 | 1
 |  |  |  |  |  |  |  |  | Double | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  | Double | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Triple | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  | Triple | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0
1. Count Each Skin won by player and put it in spreadsheet
2. Highlight lowest score in gross and net
3. payout total to each player based on skins won