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!
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!
Last edited by soeyaza; 05-20-2022 at 01:21 AM.
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
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;
To work out which game was the first of the last 6![]()
Please Login or Register to view this content.
Then
To work out the row of that fixture. Note that this is a CSE (array) formula and must be entered with Ctrl + Shift + Enter/![]()
Please Login or Register to view this content.
(see attached)
Note that I haven't tested this thoroughly. I'll leave that up to you.![]()
Last edited by Croweater; 05-25-2022 at 05:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks