Spreadsheet: 875255d1721837359-golf-leaderboard-help-southport-scoringv1
Sheet: Individuals Scoring

 | Hesketh Golf Club Southport |  | Date: |  | 2024-09-13 00:00:00 |  |  |  |  | Results Day 1 |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 24 |  |  |  |  | Results Day 2 |  |  |  |  |  | Overall Results
 | Name |  | Score |  | [NAME] |  | [NAME] | Rank |  | Rank |  | Name |  | Points |  |  | Name |  | Score |  | [NAME] |  | [NAME] |  |  | Rank |  | Name |  | Points |  | Rank |  | Name |  | Points
 | [NAME] |  | 40 |  | 13 |  | 97 | 2 |  | 1 |  | Trevor |  | 101 |  |  | [NAME] |  | 57 |  | 30 |  | 78 | 1 |  | 1 |  | [NAME] |  | 78 |  | 1 |  | [NAME] |  | 78
 | [NAME] |  | 54 |  | 36 |  | 71 | 3 |  | 2 |  | [NAME] |  | 97 |  |  | [NAME] |  | 57 |  | 39 |  | 69 | 7 |  | 2 |  | Billy |  | 76 |  | 2 |  | Billy |  | 76
 | [NAME] |  | 71 |  | 50 |  | 57 | 6 |  | 3 |  | [NAME] |  | 71 |  |  | [NAME] |  | 59 |  | 38 |  | 70 | 5 |  | 3 |  | [NAME] |  | 75 |  | 3 |  | [NAME] |  | 75
 | [NAME] |  | 135 |  | 103 |  | 35 | 10 |  | 4 |  | [NAME] |  | 65 |  |  | [NAME] |  | 72 |  | 40 |  | 68 | 8 |  | 4 |  | [NAME] |  | 74 |  | 4 |  | [NAME] |  | 74
 | [NAME] |  | 64 |  | 42 |  | 65 | 4 |  | 5 |  | Billy |  | 64 |  |  | [NAME] |  | 72 |  | 50 |  | 58 | 10 |  | 5 |  | [NAME] |  | 70 |  | 5 |  | [NAME] |  | 70
 | [NAME] |  | 72 |  | 51 |  | 56 | 8 |  | 6 |  | [NAME] |  | 57 |  |  | [NAME] |  | 54 |  | 33 |  | 75 | 3 |  | 6 |  | Martyn |  | 70 |  | 6 |  | Martyn |  | 70
 | Martyn |  | 81 |  | 50 |  | 57 | 7 |  | 7 |  | Martyn |  | 57 |  |  | Martyn |  | 69 |  | 38 |  | 70 | 6 |  | 7 |  | [NAME] |  | 69 |  | 7 |  | [NAME] |  | 69
 | Trevor |  | 37 |  | 6 |  | 101 | 1 |  | 8 |  | [NAME] |  | 56 |  |  |  |  | 77 |  | 46 |  | 62 | 9 |  | 8 |  | [NAME] |  | 68 |  | 8 |  | [NAME] |  | 68
 | Billy |  | 73 |  | 43 |  | 64 | 5 |  | 9 |  | [NAME] |  | 44 |  |  | Billy |  | 62 |  | 32 |  | 76 | 2 |  | 9 |  | 0 |  | 62 |  | 9 |  | 0 |  | 62
 | [NAME] |  | 88 |  | 64 |  | 44 | 9 |  | 10 |  | [NAME] |  | 35 |  |  | [NAME] |  | 58 |  | 34 |  | 74 | 4 |  | 10 |  | [NAME] |  | 58 |  | 10 |  | [NAME] |  | 58
 | [NAME] |  | 108 |  | 100 |  | 11 | 11 |  | 11 |  | [NAME] |  | 11 |  |  | [NAME] |  | 62 |  | 54 |  | 54 | 11 |  | 11 |  | [NAME] |  | 54 |  | 11 |  | [NAME] |  | 54
 |  |  | 0 |  |  |  | 0 | 12 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 12
 | Hesketh Golf Club Southport |  | Date: |  | 2024-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 2024
 | Team |  | Score |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  | Team |  | Score |  | [NAME] |  | [NAME] |  |  | I need to combine the ranks, names & points totals from Columns K,M,O & AA,AC,AE into the table under Columns AG,AI& AK to give me an overall rank,Name & Points
 |  |  | 40 |  | 13 |  | 97 |  |  |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 0 |  | 97
 | [NAME] |  | 54 |  | 36 |  | 71 |  |  |  |  |  |  |  |  |  | [NAME] |  | 54 |  | 36 |  | 71
 | [NAME] |  | 71 |  | 50 |  | 57 |  |  |  |  |  |  |  |  |  | [NAME] |  | 71 |  | 50 |  | 57
 | [NAME] |  | 135 |  | 103 |  | 35 |  |  |  |  |  |  |  |  |  | [NAME] |  | 135 |  | 103 |  | 35
 | Total |  | 300 |  | 202 |  | 260 |  |  |  |  |  |  |  |  |  | Total |  | 260 |  | 189 |  | 260
 | [NAME] |  | 64 |  | 42 |  | 65 |  |  |  |  |  |  |  |  |  | [NAME] |  | 64 |  | 42 |  | 65
 | [NAME] |  | 72 |  | 51 |  | 56 |  |  |  |  |  |  |  |  |  | [NAME] |  | 72 |  | 51 |  | 56
 | Martyn |  | 81 |  | 50 |  | 57 |  |  |  |  |  |  |  |  |  | Martyn |  | 81 |  | 50 |  | 57
 | Trevor |  | 37 |  | 6 |  | 101 |  |  |  |  |  |  |  |  |  | Trevor |  | 37 |  | 6 |  | 101
 | Total |  | 517 |  | 149 |  | 279 |  |  |  |  |  |  |  |  |  | Total |  | 477 |  | 149 |  | 279
 | Billy |  | 73 |  | 43 |  | 64 |  |  |  |  |  |  |  |  |  | Billy |  | 73 |  | 43 |  | 64
 | [NAME] |  | 88 |  | 64 |  | 44 |  |  |  |  |  |  |  |  |  | [NAME] |  | 88 |  | 64 |  | 44
 | [NAME] |  | 108 |  | 100 |  | 11 |  |  |  |  |  |  |  |  |  | [NAME] |  | 108 |  | 100 |  | 11
 | Ghost |  | 0 |  | -22 |  | 0 |  |  |  |  |  |  |  |  |  | Ghost |  | 0 |  | -22 |  | 0
 | Total |  | 269 |  | 185 |  | 119 |  |  |  |  |  |  |  |  |  | Total |  | 269 |  | 185 |  | 119