Spreadsheet: 875336d1721920528-golf-leaderboard-help-v2-help-on-ranking-cells-southport-scoringv2
Sheet: Results

 |  |  | Day 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall Results
 |  |  |  |  | Date: |  |  |  |  |  |  | Individual Results Day 1 |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 24 |  |  |  |  | Individual Results Day 2 |  |  |  |  |  | Individual Overall Results
 | No. |  | Name |  | Score |  | [NAME] |  | [NAME] | Rank |  | Rank |  | Name |  | Points |  |  | Name |  | Score |  | [NAME] |  | [NAME] |  |  | Rank |  | Name |  | Points |  | Rank |  | Name |  | Points
 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | [NAME] |  | 195
 | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2 |  | Trevor |  | 163
 | 3 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 3 |  | [NAME] |  | 140
 | 4 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  | Billy |  | 140
 | 5 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  | [NAME] |  | 131
 | 6 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  | 6 |  | [NAME] |  | 127
 | 7 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  | 7 |  | Martyn |  | 127
 | 8 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | Trevor |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  | [NAME] |  | 123
 | 9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  | 9 |  | [NAME] |  | 118
 | 10 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  | [NAME] |  | 118
 | 11 |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  | 11 |  | [NAME] |  | 103
 | 12
 |  |  |  |  | Date: |  |  |  |  |  |  | Team Results Day 1 |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 2024 |  |  |  |  | Team Results Day 2 |  |  |  |  |  | Overall Team Results
 | No. |  | Team |  | Score |  | [NAME] |  | [NAME] |  |  | Rank |  | Name/Team |  | Points |  |  | Team |  | Score |  | [NAME] |  | [NAME] |  |  | Rank |  | Name/Team |  | Points |  | Rank |  | Name/Team |  | Points
 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2
 |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | 3 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 3
 |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | The column in yellow needs to display the team members that are selected from the group of 12 names. I don’t know which members are in each team yet. What I would like to do is input for example is Dave, Billy, Ben & John for team 1 enter those names into Column D & T (Team 1) and then do the same for Teams 2 & 3. These teams will stay the same for both Hesketh & Old links
 |  |  | The column in blues need to pull the data from the scores, Nett Score & Stableford Points in Score A for Hesketh & Score B for Old links
 |  |  | Column in greed needs to rank the teams from 1st to 3rd each day along with the team names
 |  |  | Column in red needs to total the number of points in Column J & Z based on the highest first
 |  |  | Column in Orange needs to rank the team name(s) and there points total pullin gthe data from Team Results 1 & 2