Spreadsheet: 678668d1589999425-need-equation-to-calculate-how-many-times-a-golfer-has-played-with-other-golfers-matrix-development-upload-
Sheet: Sheet1

 |  |  | DATA TABLE
 |  |  |  | Golfers
 |  |  | Date | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Brant | [NAME] | Scott
 |  |  | 2019-05-05 00:00:00 | n | n | Group 1 | n | Group 2 | Group 1 | Group 2 | Group 2 | n | Group 1
 |  |  | 2019-05-12 00:00:00 | Group 2 | n | Group 2 | n | n | Group 1 | Group 1 | Group 2 | n | Group 1 |  |  | Group 2
 |  |  | 2019-05-19 00:00:00 | n | Group 2 | Group 1 | Group 2 | Group 2 | Group 2 | n | Group 2 | Group 2 | n |  |  | n
 |  |  | 2019-05-26 00:00:00 | Group 2 | n | Group 1 | Group 1 | Group 2 | Group 2 | Group 2 | n | n | Group 2 |  |  | Group 2
 |  |  | 2019-06-02 00:00:00 | Group 2 | Group 2 | n | n | n | Group 1 | n | n | Group 1 | n |  |  | Group 2
 |  |  | 2019-06-09 00:00:00 | Group 1 | Group 2 | n | Group 2 | n | Group 2 | Group 2 | n | Group 2 | n |  |  | Group 1
 |  |  | 2019-06-16 00:00:00 | n | Group 2 | Group 1 | Group 2 | Group 2 | n | n | Group 1 | n | Group 2 |  |  | n
 |  |  | 2019-06-23 00:00:00 | Group 2 | n | Group 1 | Group 1 | Group 2 | Group 2 | n | Group 2 | n | Group 1 |  |  | Group 2
 |  |  | 2019-06-30 00:00:00 | Group 1 | Group 2 | n | Group 2 | Group 1 | Group 2 | n | Group 2 | n | n |  |  | Group 1
 |  |  | 2019-07-07 00:00:00 | Group 2 | Group 1 | Group 2 | Group 2 | Group 2 | n | n | n | Group 2 | Group 2 |  |  | Group 2
 |  |  | 2019-07-14 00:00:00 | n | Group 1 | Group 1 | Group 2 | Group 2 | n | Group 2 | n | Group 2 | Group 2 |  |  | n
 |  |  | 2019-07-21 00:00:00 | n | Group 2 | Group 1 | Group 2 | n | Group 2 | Group 1 | Group 2 | n | Group 2 |  |  | n
 |  |  | 2019-07-28 00:00:00 | n | Group 1 | n | n | Group 1 | n | Group 2 | Group 1 | Group 2 | Group 2 |  |  | n
 |  |  | 2019-08-04 00:00:00 | Group 2 | n | Group 2 | n | Group 2 | n | n | Group 1 | Group 1 | Group 2 |  |  | Group 2
 |  |  | 2019-08-11 00:00:00 | n | Group 2 | Group 2 | Group 2 | n | Group 2 | Group 2 | n | Group 1 | Group 2 |  |  | n
 |  |  | 2019-08-18 00:00:00 | Group 2 | Group 2 | Group 1 | n | Group 2 | Group 2 | n | n | n | Group 1 |  |  | Group 2
 |  |  | 2019-08-25 00:00:00 | Group 2 | n | Group 2 | n | Group 1 | Group 2 | n | Group 2 | n | Group 2 |  |  | Group 2
 |  |  | 2019-09-01 00:00:00 | Group 2 | n | Group 2 | Group 2 | n | Group 1 | n | Group 2 | n | Group 2 |  |  | Group 2
 |  |  | 2019-09-08 00:00:00 | Group 2 | Group 2 | n | n | n | Group 2 | n | Group 2 | Group 2 | n |  |  | Group 2
 |  |  | 2019-09-15 00:00:00 | Group 2 | Group 1 | Group 2 | Group 2 | Group 2 | Group 2 | n | Group 2 | Group 2 | n |  |  | Group 2
 |  |  | 2019-09-22 00:00:00 | n | Group 1 | Group 1 | Group 2 | n | Group 1 | Group 2 | Group 1 | Group 2 | Group 2 |  |  | n
 |  |  | 2019-09-29 00:00:00 | Group 2 | Group 2 | n | Group 2 | n | Group 2 | n | Group 1 | Group 1 | Group 2 |  |  | Group 2
 |  |  | 2019-10-06 00:00:00 | n | n | Group 1 | Group 2 | n | Group 2 | Group 2 | Group 2 | n | Group 1 |  |  | n
 |  |  | 2019-10-13 00:00:00 | Group 2 | n | Group 2 | Group 2 | Group 2 | n | n | Group 2 | n | Group 1 |  |  | Group 2
 |  |  | DESIRED RESULTS TABLE (HOW MANY TIMES A PLAYER HAS PLAYED WITH EACH OTHER PLAYER)
 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Brant | [NAME] | Scott
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Brant
 |  |  | [NAME]
 |  |  | Scott