Hi,
I need to construct a table that counts the number of times two players show up on the same row.
This is a golfing tournament with 4 rounds and 12 players. I need to see how many times each player plays in the same foursome with the other individuals.
Thanks in advance - my mind is shot from doing VBA. I don't know if this is a CSE formula a SumProduct or Countifs.![]()
See the attached for the sample.
Bookmarks