Hi Everyone,
I'm trying to automate some statistics for my softball league, and one of the things I want to look at is opponent's Win-Loss record. I want to solve the problem using array formulas, but I can't seem to crack it. We have a table of home team/away team and another table of standings. I think I need to use an array of the home teams, find out their relative positions, then offset that by 1 to see the away team, then lookup their wins and add them together. Below is a copy hosted in my SkyDrive. Thanks for your help!
https://skydrive.live.com/redir?resid=12FA5A01BB7C3364!128&authkey=!AEiUGp6Se10z8No
I'm trying to automate some statistics for my softball league, and one of the things I want to look at is opponent's Win-Loss record. I want to solve the problem using array formulas, but I can't seem to crack it. We have a table of home team/away team and another table of standings. I think I need to use an array of the home teams, find out their relative positions, then offset that by 1 to see the away team, then lookup their wins and add them together. Below is a copy hosted in my SkyDrive. Thanks for your help!
https://skydrive.live.com/redir?resid=12FA5A01BB7C3364!128&authkey=!AEiUGp6Se10z8No