Spreadsheet: 738860d1625302673-adding-a-max-to-a-formula-to-prevent-a-return-of-a-minus-result-midshires-master
Sheet: playlist

 | Our Next Event of the 2021 season is…….
 | European |  |  | at Southerndown
 | Friday 25th June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAYER INDEX
 | Nearest the pins:    in 1 = 10th    in 2 = 9th    in 3 = 13th |  |  | Captains Bottle = 14th |  | Longest Drive = 8th |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 31
 | GROUP | Tee-Time | Player | Official Handicap | Adjustment | Playing Handicap |  | POINTS | POST | POINTS | POST |  | OFF PTS | S/I1 | S/I2 | S/I3 | 00:10:00 |  |  | 2 |  | 32 |  |  |  |  | H'Cap | To Pay
9 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 33
51 |  | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 34
37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 35
41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 36
60 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 37
32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 38
43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 39
65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 40
56 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 41
57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 42
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 43
44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 44
1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 45
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 46
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 47
47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 48
10 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 49
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 50
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 51
46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 52
17 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 53
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 54
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 55
45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 56
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 60
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 | 11
 | 12
 | 13