Hi All,
Another project I am working on. I have a database of football results. I am trying to create a visual via a formula rather than linking manually.
I am trying to get a football teams most recent last 5 results. The 5 most recent Home results for the team playing at home today and the 5 most recent Away results for the team playing Away today.
I’ve set a dummy game up, Liverpool v Leeds.
On Sheet 2 I have manually linked the end result I would like to do. Is there a way I can do this via a formula though?
My football database is in the tab titled ALL.
This is the end result I would like to see.
This is the copy of Leeds Away data. the columns I am interested in picking data up from is Column B, the date. (I have this ordered oldest to newest). Column E the Away team name and Column H, the Full time Result.
Similarly, for Liverpool the columns I am interested in picking data up from is Column B, the date. (I have this ordered oldest to newest). Column D the Home team name and Column H, the Full time Result.
Is there a way I can put formulas in Cells C5:L5 of Sheet 2 to capture the data I want please?
Any help greatly appreciated.
Kind regards,
James
Another project I am working on. I have a database of football results. I am trying to create a visual via a formula rather than linking manually.
I am trying to get a football teams most recent last 5 results. The 5 most recent Home results for the team playing at home today and the 5 most recent Away results for the team playing Away today.
I’ve set a dummy game up, Liverpool v Leeds.
On Sheet 2 I have manually linked the end result I would like to do. Is there a way I can do this via a formula though?
My football database is in the tab titled ALL.
This is the end result I would like to see.
This is the copy of Leeds Away data. the columns I am interested in picking data up from is Column B, the date. (I have this ordered oldest to newest). Column E the Away team name and Column H, the Full time Result.
Similarly, for Liverpool the columns I am interested in picking data up from is Column B, the date. (I have this ordered oldest to newest). Column D the Home team name and Column H, the Full time Result.
Is there a way I can put formulas in Cells C5:L5 of Sheet 2 to capture the data I want please?
Any help greatly appreciated.
Kind regards,
James