Thread: Head to head
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Noob Jedi Noob Jedi is offline
external usenet poster
 
Posts: 33
Default Head to head

I'm trying to statistically capture head-to-head occurences in a
sports league. Out of 120 teams, I want to capture only 35 of those
teams and how many times there is a head-to-head occurence within that
pool of 35. I know the schedule will show something like "Team1 vs
Team 2" and then "Team 2 vs Team 1." If they are referring to the same
game, I only want to count it as one occurence. Does anyone have a
method or spreadsheet that can help me do this?