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" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them 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 6Please 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.
Sorry for my absence.
I cannot open your attached file.
Please repair it for me to open.
Last edited by AliGW; 02-22-2023 at 10:44 AM. Reason: Please do NOT quote unnecessarily!
There is nothing wrong with the attached file - it opens perfectly.
I have tried again and again but it didn't open.
I tried it on my mobile with an app.
Thanks a lot to both of you and the forum family.
I could have opened it.
So I am confused. Did you manage to get it open?
You will need to open it on a desktop or laptop, not using a mobile app.
I managed to open it and I can use it to create other league tables with 20 teams. But I can't create English Championship League that includes 24 teams.
You might find a workbook at this site that can be used/modified for 24 teams: https://spreadsheetpage.com/sport/#soccer
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
So put up what you HAVE got for the Championship League and I'll have a look at it when I get time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks