+ Reply to Thread
Results 1 to 4 of 4

Struggling to rank teams in a league table

  1. #1
    Registered User
    Join Date
    05-24-2022
    Location
    United Kingdom
    MS-Off Ver
    2016 Pro
    Posts
    2

    Question Struggling to rank teams in a league table

    Cross posted at https://www.mrexcel.com/board/thread...table.1205882/



    Hello all,

    I am working on a league table in excel which follows these set rules to determine the rank of the teams.
    1. Points obtained in all group matches;
    2. Goal difference in all group matches;
    3. Number of goals scored in all group matches;
    4. Points obtained in the matches played between the teams in question;
    5. Goal difference in the matches played between the teams in question;
    6. Number of goals scored in the matches played between the teams in question;


    I have had no issues ranking the teams based on points 1 - 3 however the final 3 are stumping me.

    In a league table there are 4 teams who all play each other once, 3 points for a win, 1 for a draw, 0 for a loss. With certain conditions 3 teams can all have the same number of points, same goal difference and same number of goals scored.

    I currently have a terrible IF function that says does team 1 rank equal teams 2 rank, if yes did team 1 beat team 2 then team 1 scores higher, if no does team 1 rank equal team 3 rank, and so on.

    This only allows me to compare 2 teams against each other against the criteria for the 4th point, and also does not consider the inevitable 3 team tie up.

    Any ideas on how to go about this problem would be greatly appreciated. Also I would really love to stay away from VBA as I would like my workbook to remain macro free!

    Cheers!
    James
    Last edited by 6StringJazzer; 05-24-2022 at 05:32 PM.

  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,327

    Re: Struggling to rank teams in a league table

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    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
    Registered User
    Join Date
    05-24-2022
    Location
    United Kingdom
    MS-Off Ver
    2016 Pro
    Posts
    2

    Re: Struggling to rank teams in a league table

    Good suggestion. I have attached an example workbook. See below.

    Thanks again all.
    Attached Files Attached Files

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Struggling to rank teams in a league table

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    I have added the link for you since it's your first thread.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Rank / League table (Dynamic Data)
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2021, 04:48 AM
  2. [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
  3. Hi Every one Rank Lawn green bowling league table
    By jtd Clarke in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-07-2016, 05:14 AM
  4. Rank Teams in Performance Order - not as easy as just =Rank...
    By excelnat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2015, 12:12 PM
  5. [SOLVED] Rank League Table ignoring BYE
    By kevinmcilroy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2014, 03:21 PM
  6. Rank League Table
    By adam2308 in forum Excel General
    Replies: 3
    Last Post: 03-19-2014, 03:23 PM
  7. Replies: 1
    Last Post: 05-14-2008, 02:59 PM

Tags for this Thread

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