Here's a Month worth. It contains Date Played, who played on that date and the Pairing (1A played together on that day, 1B played together on that day, 18A played together on that day, etc.). I'm trying to solve how many times each player has been Paired with the other players in the list. Using COUNTIFS I can determine how many times each player has played but not how many times for example Gary has played with Matt, Lyle, Glenn, etc. Any help is greatly appreciated.
Thanks in advance
[TABLE="width: 316"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Pairing[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Blender,Matt[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Francini,Glenn[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]D'Alonzo,Rudy[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Pollock,Joe[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Motil,Joe[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Busby,Fred[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Milton,Rick[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Farley,Ed[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Vandenbergh,Lew[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Hay,Albert[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Rogers,Dermott[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Tribble,Joe[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Milton,Rick[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Busby,Fred[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Jones,Jerry[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Sigler,John[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]D'Alonzo,Rudy[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Francini,Glenn[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Burros,Don[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Farley,Ed[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 14, 2016[/TD]
[TD]Pollock,Joe[/TD]
[TD]17A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Campbell,Joe[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Hall,Joel[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Leines,Egil[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Dolan,Rick[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Burros,Don[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Pollock,Joe[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Vandenbergh,Lew[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 15, 2016[/TD]
[TD]Gilton,Paul[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Milton,Rick[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Dolan,Rick[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Gilton,Paul[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Hall,Joel[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Burros,Don[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Elberson,Gil[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Dalbey,Don[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Busby,Fred[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]D'Alonzo,Rudy[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 21, 2016[/TD]
[TD]Vandenbergh,Lew[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Francini,Glenn[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Elberson,Gil[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Leines,Egil[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Dolan,Rick[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Campbell,Joe[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 23, 2016[/TD]
[TD]Dalbey,Don[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Gilton,Paul[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 26, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Farley,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Hall,Joel[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Francini,Glenn[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]D'Alonzo,Rudy[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Dalbey,Don[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 28, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Leines,Egil[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Farley,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Francini,Glenn[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Gilton,Paul[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Dolan,Rick[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Etter,Alan[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Pollock,Joe[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Campbell,Joe[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]September 30, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]October 3, 2016[/TD]
[TD]Etter,Alan[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 3, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 3, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 3, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 3, 2016[/TD]
[TD]Kaucher,****[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]D'Alonzo,Rudy[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Gastley,****[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Farley,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Jones,Jerry[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Elberson,Gil[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Busby,Fred[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 5, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Tribble,Joe[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Elberson,Gil[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Hiles,Ed[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Dahlenburg,Lyle[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Cook,Tom[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Habiger,Andy[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Dolan,Rick[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Batlle,Jose[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]White,Marshall[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Leines,Egil[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Goodroe,Ken[/TD]
[TD]18A[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Wingo,Gary[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Brown,Larry[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Pollock,Joe[/TD]
[TD]18B[/TD]
[/TR]
[TR]
[TD]October 7, 2016[/TD]
[TD]Coats,JC[/TD]
[TD]18B[/TD]
[/TR]
</tbody>[/TABLE]