+ Reply to Thread
Results 1 to 12 of 12

League table for last 6 matches

  1. #1
    Registered User
    Join Date
    08-16-2009
    Location
    mandalay,myanmar
    MS-Off Ver
    Excel 2003
    Posts
    22

    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!
    Attached Files Attached Files
    Last edited by soeyaza; 05-20-2022 at 01:21 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: League table for last 6 matches

    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.

  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: League table for last 6 matches

    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.
    Attached Files Attached Files
    Last edited by Croweater; 05-25-2022 at 05:45 AM.

  4. #4
    Registered User
    Join Date
    08-16-2009
    Location
    mandalay,myanmar
    MS-Off Ver
    Excel 2003
    Posts
    22
    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!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: League table for last 6 matches

    There is nothing wrong with the attached file - it opens perfectly.

  6. #6
    Registered User
    Join Date
    08-16-2009
    Location
    mandalay,myanmar
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: League table for last 6 matches

    I have tried again and again but it didn't open.
    I tried it on my mobile with an app.

  7. #7
    Registered User
    Join Date
    08-16-2009
    Location
    mandalay,myanmar
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: League table for last 6 matches

    Thanks a lot to both of you and the forum family.
    I could have opened it.

  8. #8
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: League table for last 6 matches

    So I am confused. Did you manage to get it open?

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: League table for last 6 matches

    You will need to open it on a desktop or laptop, not using a mobile app.

  10. #10
    Registered User
    Join Date
    08-16-2009
    Location
    mandalay,myanmar
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: League table for last 6 matches

    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.

  11. #11
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: League table for last 6 matches

    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.

  12. #12
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: League table for last 6 matches

    So put up what you HAVE got for the Championship League and I'll have a look at it when I get time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] League Table auto update RANK goes lower than avaliabe on table
    By killhi12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2019, 04:48 PM
  2. [SOLVED] Extend currnt table whilst keeping the Formula (Create a live league table)
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2018, 02:11 PM
  3. Sorting Help based on Game results
    By darkblueblood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2014, 04:00 PM
  4. league team matches
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2010, 07:12 PM
  5. Replies: 3
    Last Post: 05-15-2010, 10:12 AM
  6. create league table :: enter result :: update table
    By Eng.Soly in forum Excel General
    Replies: 2
    Last Post: 12-27-2008, 06:31 AM
  7. Sorting Data Table (league table)
    By Cul in forum Excel General
    Replies: 2
    Last Post: 09-13-2007, 05:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1