+ Reply to Thread
Results 1 to 4 of 4

calculate standings (sports)

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    27

    calculate standings (sports)

    Hi all,
    Im trying to build a formula which calculates the standings in a for example football competition.
    I looked on internet to see if I could find a link.
    Ive been creative myself which resulted in the attachment.

    It works pretty well, except when 2 teams end the same. I want goal difference to make a rank.

    P1:C6 is tabel with ranking
    F11:I16 are results
    K19:N22 is goal difference

    its worksheet "deelnemende landen"

    I just dont know how I can work goal difference in the table formula if 2 teams end with the same amount of point.

    Anyone can help me?
    If anyone knows another worksheet for calculating tables for for example football results I would be more then happy too.

    thx in advance
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,600

    Re: calculate standings (sports)

    Bob Phillips has one at his site, here:

    http://www.xldynamic.com/source/xld.LeagueTable.html

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: calculate standings (sports)

    Hi

    Please click on attachment

    Cheer
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    06-21-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: calculate standings (sports)

    thanx guys. Both replies are very usefull

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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