Let me start by greeting everyone in the name of Excel. I am working on something that will look up data of football team results, both home and away. No vba please I have encountered a significant challenge. I have data for 20 football teams, each having played 38 games. I have their results, dates, and times. Let's say I want a formula that, when I look up "Man U," it brings up all of Manchester United's games: date, time, home and away games, and results. I am not entirely sure if my data is structured correctly. My data, spanning over 750 rows, is structured as follows: Date column, time column, home team column, results for the home team column, results for the away team column, and away team column.
🔵 FREE FILE TO DOWNLOAD: jopaexcel.com/wp-content/uploads/2024/03/Lambda-BYfILBUC1nc.xlsx
Let me start by greeting everyone in the name of Excel.
I am working on something that will look up data of football team results, both home and away.
No vba please
I have encountered a significant challenge. I have data for 20 football teams, each having played 38 games. I have their results, dates, and times. Let's say I want a formula that, when I look up "Man U," it brings up all of Manchester United's games: date, time, home and away games, and results.
I am not entirely sure if my data is structured correctly.
My data, spanning over 750 rows, is structured as follows: Date column, time column, home team column, results for the home team column, results for the away team column, and away team column.