Hello! This is really difficult to explain so it's best to look at the sample worksheet. I'm attempting to match 2 sport team's head-to-head results from a list of results, but I can only figure out how to match the most recent game they played against each other.
These are the steps I'm hoping to recreate:
- Input Team1's name in I1, and the Team2's name in L1
- It should then find all the instances where in the results section, Team1 & Team2 appear together in columns B & D (In any order)
- It should return the most recent game first, then find the second to most recent game and return that in the following row and continue
The only way I know how to do this is to match Team1 & Team2 and return the most recent game, how can I make it continue down?
Please look at the attached sample so it hopefully makes more sense. On the left is a replica of how my results columns are formatted, and on the right is what I am trying to achieve.
Thank you all in advance!
Bookmarks