I have a fixture that goes across 2 columns like this:
Team 1- Team 2
Team 1- Team 3
Team 2- Team 4
Team 3- Team 1
I would like a formula to count how many times Team 1 has played Team 2, Team 3 etc. and if possible, how many times they win (which is in a separate column). Obviously i could count them, but i have a big league with lots of games and that would be very tedious.
Bookmarks