I've done several searches on the subject and though most results are close, none seems to be exactly what I'm looking for. So I figured I would turn to the pros.
I have a sheet with an athletic scoring system.
For example: (A1)Team A, (B1)Points For, (C1)Points Against, (D1)Opposing Team
Since this is a league, these teams play each other several times. Team A may be home one week, visiting the next.
For example: Team A, 2, 3, Team B and next game Team B, 3, 5, Team A.
Keep in mind there are several teams and obviously several scoring outcomes.
What I'm trying to do is find a code that would search the teams I would place in cell F1 and G1, and generate a list right below (F2:F20 & G2:G20) of the games they've played against one another and the scores of those games.
There are exactly 1230 games played between 30 different teams, if that helps any.
Any help on this would be greatly appreciated.
Thanks in advance.
Bookmarks