I have a worksheet that is finding a soccer team's home and away fixture dates in ascending order and displaying them in a separate table. The problem is I can only do it based on home or away matches separately, when ideally I want to find a way of combining a team's home and away matches by ranking based on their date.
Remember, as there is a column for the home team and another for the away side, it means that any kind of formula needs to take this into consideration. Sometimes the team will appear as the home side and other as the away team. I've been using an AGGREGATE conditional statement for the home and away teams separately:
Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
However, an #N/A error value is produced when I use both columns together:Formula:Please Login or Register to view this content.
I've attached an example that shows this.
Bookmarks