League table for last 6 matches

Dear All Friends,

I've got a template to build a soccer league table and I can do for all matches.

However, I cannot build a league table for last six matches(form table).
I hope someone will help me, please!

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

So what I did was recreate the table in the (hidden) Settings tab for the last 6 games with the aid of 2 helper columns to decide the row of the 6 to last game in the Fixtures and Results tab.

Then it was just a matter of recreating the formula in the settings (and league table) tabs using INDIRECT starting at the row worked out above instead of the row for the first game.

Formula in helper columns;

Please Login or Register  to view this content.

To work out which game was the first of the last 6

Then

Please Login or Register  to view this content.

To work out the row of that fixture. Note that this is a CSE (array) formula and must be entered with Ctrl + Shift + Enter/

(see attached)

Note that I haven't tested this thoroughly. I'll leave that up to you.