[Basel A]

Originally Posted by karomata

Other than manually tracking which matches a team played in and doing the math in calculation cells, is there a way using excel that I can have it automatically identify which matches in which cells would the team have competed in, without me having to set it to do it for that specific instance? Ex. Instead of me recording all the match data from 1511s matches into the final calculation table, the program automatically identifies which matches 1511 played in, and puts it into the table for me.

If you'd like, I'd be happy to email/show you an example of how I did this. I've put some thought into it and haven't found a really good method in Excel, but it's not hard to make it work. Essentially just create a match index based on the schedule, then do an iterative search through the index.