Can I use Excel to solve this problem

pgilton

New Member
Joined
Oct 8, 2016
Messages
4
I manage a group of 40 senior golfers and each M, W and Friday I have to submit a roster of the pairings for that particular day. My challenge is to make sure that the same people are not always playing together. I'm looking for a tool that would display a count of how many times Player A has played with Player B - Z; Player B has played with Player A, C-Z; etc? I've tried to use Pivot tables in different configurations but to date have not been able to display the result I'm looking for.
 
It is perfectly possible, but you'd need to share the layout of your file with us.
 
Upvote 0
I'm not sure how to properly use the forum to show you cells from my spreadsheet but this should do it for you:

Column A: List of Player 1 Names
Column B: List of Player 2 Names

In Column E (starting with row 2 I have a list of all potential players)
In Row 1 I have the same list of players starting in Column F and moving to the right (basically creating a matrix of names

In Cell F2 input formula: =countifs($A:$A,$E2,$B:$B,F$1)

CopyPaste Formula in the rest of the matrix.

You can then fill the cells black where a player would play themselves to not get confused and then add conditional formatting to the rest to make it easier to read.

I'm sure there are other solutions but that was the easiest way for me to see it. You can just continue to add Players and Opponents to columns A and B at will and the matrix will continue to update for you.
 
Upvote 0
Thanks For the quickreply. I understand the Matrix part and I have It built as youdescribed -- Column E Row 2 I have a list of all my players. I copied that listand Transposed it Starting in Column F Row 1 to create the matrix. I thenpasted your formula throughout the matrix. It is returning 0's everywhere butthe actual Player (Jon Doe is only finding Jon Doe).

I think My problemis in the data in Columns A and B. In Column A I have a list of all the playerswho played in September (Sample data to test). Some have played once some haveplayed nine times. in Column B I have the same exact list I'm not counting competitionsI'm trying to find out how many times Player A,Player, etc. has beenpaired with The other players in the group. I thinks I may need another data point like the dates that the players played.

Thanks in advance for your help.

 
Upvote 0
I also think your problem is with A and B... Instead of A being a list of all players in September, call A "Player 1" and call B "Player 2". In any order, you just type in each pairing and the matrix should tell you number of times played. For instance if A shows:

Bill
Tom
Bill
Bill
Frank

And B Shows:
Frank
Frank
Tom
Frank
Bill

You should see that Frank and Bill played 3 times, Frank and Tom played 1 time, and Bill and Tom played once in your matrix
 
Upvote 0
Thanks so much for your help!

Here's a small example of my actual data:

[TABLE="width: 335"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name 1[/TD]
[TD]Pairing[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Gary[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Matt[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Glenn[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Julian[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]Marshall[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[TD]****[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Rudy[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Lyle[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Joe[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Julian[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Jose[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]September 9, 2016[/TD]
[TD]Joe[/TD]
[TD]1B[/TD]
[/TR]
</tbody>[/TABLE]

On September 5 Lyle was paired with Gary and Matt (Pairing 1A); Julian was paired with ****, Marshall and Glenn (Pairing 1B). On Sept 9 Lyle was paired with Joe and Rudy (Pairing 1A); Julian was paired with Jose and Joe (Pairing 1B). When I have those same names in both Column A and B COUNTIFS only returns data where the name is the same (Lyle 2, Julian 2, all others 1.

What I thought I would see was that Lyle has played with Gary, Matt (on 9/5) Joe and Rudy (on 9/9); likewise for Julian and the others. Maybe I just don't understand how countifs works.

Thanks for your patience.
 
Upvote 0
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]
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top