Please see the attachment.
On sheet Data I have a list of soccer matches (A:B) played on various dates (C:C) with results (D:E) and statistics (F:G) plus some counter columns (H:I) highlighting the most recently completed matches.
On sheet Preview I would like to separate this data as shown on the attachment, into home and away team previews.
In this example, I would like to compare Nines vs Kangas,
By writing "Nines" into cell A2 I would like to put the correct formulas into A4:G9 to complete the data as shown in the attachment. This will show the most recently played match (defined by when there is a score inserted in Data!D:E) involving Nines on the top line, and then the rest of the results below in chronological order, regardless of whether they play at home or away.
In order to achieve this, do I need to have a series of looks ups? Do I need to have a further counting column on the Data page that counts either??
Thanks,
Marco
Bookmarks