Spreadsheet: 869197d1715835607-team-comp-help-with-a-formula-to-show-each-teams-points-against-the-other-teams-points-pong-streaks-updated-2-
Sheet: Sheet1

Round | Home | Score | Score2 | Away |  |  |  |  |  |  | Round | Home | Score | Score2 | Away |  |  | For | Against |  |  |  | For | Against
1 | [NAME] | 21 | 13 | Nathan |  |  |  |  |  |  | 1 | [NAME] | 21 | 13 | Nathan
1 | [NAME] | 21 | 15 | Nathan |  |  |  |  |  |  | 1 | [NAME] | 21 | 15 | Nathan |  | [NAME] | 0 | 0 | [NAME] |  | [NAME] | 21 | 11 | [NAME]
1 | [NAME] | 11 | 4 | Nathan |  |  |  |  |  |  | 1 | [NAME] | 11 | 4 | Nathan |  | [NAME] | 74 | 41 | Nathan |  | [NAME] | 50 | 48 | Mark
1 | Nathan | 21 | 17 | [NAME] |  |  |  |  |  |  | 1 | Nathan | 21 | 17 | [NAME] |  | [NAME] | 50 | 48 | Mark |  | [NAME] | 42 | 25 | [NAME]
1 | Nathan | 21 | 14 | [NAME] |  |  |  |  |  |  | 1 | Nathan | 21 | 14 | [NAME] |  | [NAME] | 21 | 11 | [NAME] |  | [NAME] | 0 | 0 | [NAME]
1 | Nathan | 11 | 5 | [NAME] |  |  |  |  |  |  | 1 | Nathan | 11 | 5 | [NAME] |  | [NAME] | 0 | 0 | [NAME] |  | Mark | 0 | 0 | Nathan
1 | [NAME] | 21 | 18 | Mark |  |  |  |  |  |  | 1 | [NAME] | 21 | 18 | Mark |  | [NAME] | 11 | 21 | [NAME] |  | Mark | 0 | 0 | [NAME]
1 | [NAME] | 21 | 13 | [NAME] |  |  |  |  |  |  | 1 | [NAME] | 21 | 13 | [NAME] |  | [NAME] | 67 | 95 | Nathan |  | Mark | 0 | 0 | Mark
2 | [NAME] | 21 | 9 | Nathan |  |  |  |  |  |  | 2 | [NAME] | 21 | 9 | Nathan |  | [NAME] | 0 | 0 | Mark |  | Mark | 0 | 0 | [NAME]
2 | [NAME] | 21 | 11 | [NAME] |  |  |  |  |  |  | 2 | [NAME] | 21 | 11 | [NAME] |  | [NAME] | 0 | 0 | [NAME] |  | Mark | 48 | 50 | [NAME]
2 | Nathan | 21 | 17 | [NAME] |  |  |  |  |  |  | 2 | Nathan | 21 | 17 | [NAME] |  | Mark | 0 | 0 | [NAME] |  | Nathan | 0 | 0 | Nathan
2 | Nathan | 21 | 14 | [NAME] |  |  |  |  |  |  | 2 | Nathan | 21 | 14 | [NAME] |  | Mark | 48 | 50 | [NAME] |  | Nathan | 95 | 67 | [NAME]
2 | [NAME] | 21 | 12 | [NAME] |  |  |  |  |  |  | 2 | [NAME] | 21 | 12 | [NAME] |  | Mark | 0 | 0 | Nathan |  | Nathan | 0 | 0 | Mark
2 | [NAME] | 21 | 19 | Mark |  |  |  |  |  |  | 2 | [NAME] | 21 | 19 | Mark |  | Mark | 0 | 0 | Mark |  | Nathan | 0 | 0 | [NAME]
2 | Mark | 11 | 8 | [NAME] |  |  |  |  |  |  | 2 | Mark | 11 | 8 | [NAME] |  | Mark | 0 | 0 | [NAME] |  | Nathan | 41 | 74 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nathan | 0 | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nathan | 41 | 74 | [NAME]
 | For | Against |  |  |  | For | Against |  |  |  |  | For | Against |  |  |  | Nathan | 0 | 0 | Nathan
 |  |  |  |  |  | 42 | 25 | [NAME] |  |  |  | 42 | 25 | [NAME] |  |  | Nathan | 0 | 0 | Mark
[NAME] | 0 | 0 | [NAME] |  | [NAME] | 74 | 41 | Nathan |  |  | [NAME] | 74 | 41 | Nathan |  |  | Nathan | 95 | 67 | [NAME]
[NAME] | 74 | 41 | Nathan |  | [NAME] | 50 | 48 | Mark |  |  | [NAME] | 50 | 48 | Mark |  |  | [NAME] | 0 | 0 | [NAME]
[NAME] | 50 | 48 | Mark |  | [NAME] | 21 | 11 | [NAME] |  |  | [NAME] | 21 | 11 | [NAME] |  |  | [NAME] | 25 | 42 | [NAME]
[NAME] | 21 | 11 | [NAME] |  | [NAME] | 11 | 21 | [NAME] |  |  | [NAME] | 11 | 21 | [NAME] |  |  | [NAME] | 0 | 0 | Nathan
[NAME] | 0 | 0 | [NAME] |  | [NAME] | 67 | 95 | Nathan |  |  | [NAME] | 67 | 95 | Nathan |  |  | [NAME] | 0 | 0 | Mark
[NAME] | 11 | 21 | [NAME] |  | Mark | 48 | 50 | [NAME] |  |  | Mark | 48 | 50 | [NAME] |  |  | [NAME] | 0 | 0 | [NAME]
[NAME] | 67 | 95 | Nathan |  | Nathan | 41 | 74 | [NAME] |  |  | Nathan | 41 | 74 | [NAME]
[NAME] | 0 | 0 | Mark |  | Nathan | 95 | 67 | [NAME] |  |  | Nathan | 95 | 67 | [NAME]
[NAME] | 0 | 0 | [NAME] |  | [NAME] | 25 | 42 | [NAME] |  |  | [NAME] | 25 | 42 | [NAME]
Mark | 0 | 0 | [NAME]
Mark | 48 | 50 | [NAME] |  |  |  |  |  |  |  |  | For | Against
Mark | 0 | 0 | Nathan |  |  |  |  |  |  |  |  | 74 | 41 | Nathan
Mark | 0 | 0 | Mark |  |  |  |  |  |  |  | [NAME] | 21 | 11 | [NAME]
Mark | 0 | 0 | [NAME] |  |  |  |  |  |  |  | [NAME] | 50 | 48 | Mark
Nathan | 0 | 0 | [NAME] |  |  |  |  |  |  |  | [NAME] | 42 | 25 | [NAME]
Nathan | 41 | 74 | [NAME] |  |  |  |  |  |  |  | Mark | 48 | 50 | [NAME]
Nathan | 0 | 0 | Nathan |  |  |  |  |  |  |  | Nathan | 95 | 67 | [NAME]
Nathan | 0 | 0 | Mark |  |  |  |  |  |  |  | Nathan | 41 | 74 | [NAME]
Nathan | 95 | 67 | [NAME]
[NAME] | 0 | 0 | [NAME]
[NAME] | 25 | 42 | [NAME]
[NAME] | 0 | 0 | Nathan
[NAME] | 0 | 0 | Mark
[NAME] | 0 | 0 | [NAME]