+ Reply to Thread
Results 1 to 9 of 9

Help with football league table

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    beograd, serbia
    MS-Off Ver
    2007
    Posts
    7

    Help with football league table

    Hi, as you can see on the attachment, Tottenham Hotspur and Everton appear twice, can some help me with that? Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Help with football league table

    Where is the "Calculations" worksheet referenced in the "League Table" vlookups in Columns C-O?

  3. #3
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Help with football league table

    Here it is, fixed. You need to use a tie-breaking score to rank the teams, using Goal Difference, and Goals For as the first and second tie-breakers, and an alphabetizing value in case they are still tied.

    Premeir league Fixture list and table.xlsm
    Last edited by Bernie Deitrick; 09-25-2014 at 02:09 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Help with football league table

    It is hidden in his, showing in mine....

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Help with football league table

    Does this help?

    Jim O

  6. #6
    Registered User
    Join Date
    09-24-2014
    Location
    beograd, serbia
    MS-Off Ver
    2007
    Posts
    7

    Re: Help with football league table

    I have found the problem literally 30secunds after posting this But thank everybody.

  7. #7
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Help with football league table

    Then literally 31 seconds after posting, you should have deleted your post to not waste everybody's time.

  8. #8
    Registered User
    Join Date
    09-24-2014
    Location
    beograd, serbia
    MS-Off Ver
    2007
    Posts
    7

    Re: Help with football league table

    Wow chill, im sorry i couldnt find that option.

  9. #9
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Help with football league table

    You can always edit your post to say "That's Ok - found my solution which was to do this <specific change>, in case anybody has a similar problem......"

+ 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. sort 40 football league table
    By peterfc2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2014, 05:43 AM
  2. Football League Table
    By Falconair in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2013, 03:25 PM
  3. Formula Help - Football League Table
    By chaser2k12 in forum Excel General
    Replies: 6
    Last Post: 06-27-2012, 10:42 AM
  4. football league table
    By rocky123 in forum Excel General
    Replies: 8
    Last Post: 07-24-2009, 11:47 AM
  5. Football League Table
    By Crucfier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2005, 05:05 PM

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