Most recent 6 values

[RedPed]

I have some football data where I have data for completed matches and also upcoming fixtures.

I would like to show the the number of goals scored by each team form their most recent 6 matches played (note that this will include both home and away matches played by the teams). example screenshot of completed matches below and an example of the upcoming fixtures. Is this possible or do I need to think of another solution?

 

[Peter_SSs]

I can't find any documentation to explain what those curly braces and "" are doing in the FILTER

You were using CHOOSECOLS to choose columns 1, 2 & 4 in one part and columns 1, 3 & 5 in the other. To do that you need to have at least 4 columns in that first part and at least 5 columns in the second part. The { ...} sections were creating those (empty) columns, when the FILTER returned nothing else, so that CHOOSECOLS did not error.