Hello
I've a excel file for sport games. Right now i'm working on a specific game , the AFL.
In this file, i have a sheet with the games ( Sheet Jogos ) and i've the sheet data with all the games since 2009.
I'm trying to show all the head to head previous matches between 2 teams.
Example:
At 15 May , i've 9 games in the sheet Jogos, changing the date , it changes the games . The first game is North Melbourne vs Essendon. In the sheet Data , i've all the games played in past seasons and i want a formula to show only the previous head to head matches for all the 9 games defined in th sheet Jogos.
I attached the file.
Thanks in advance
Best regards
Bookmarks