to create a table of the last six events from a long list.

[andyh42]

Hi,

I want to create a table of last six matches and the goal difference for each team. The attached file has all results for the season so far but I only want the last six matches and the accumulated goal difference for each team for those six matches both home and away. The matches will not be spilt even so 4 matches could be home and 2 away or any other combination.
example:
Team Played Goal diff.
Arsenal 6 +6
Brighton 6 -3 etc.

each match has an individual number as using dates I feel will cause more problems.

Thanks.

[bebo021999]

I created 2 name: List to define list of matches of specific team and Diff for diffent goals
See attachment

[andyh42]

That's great!

Have a good day and thank you very much.