+ Reply to Thread
Results 1 to 3 of 3

Soccer league table

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Inverness, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Soccer league table

    Hello,

    Using Excel 2007

    I would like a formula for 1st, 2nd, 3rd, 4th league positions in cells M5,M6,M7,M8 that displays the team name based on a league, firstly by the total points accumulated col J5-J8, followed by Goal difference (I5-I8), then lastly the Goals For (G5-G8)
    .

    I have attached an image showing the correct results edited by hand - but without the formula.
    Any help greatly received.

    Regards,
    Iain...


    I Soccer League Table.jpg

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

    Re: Soccer league table

    Hi

    Welcome to the forum.

    Please click on the attachment
    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".

  3. #3
    Registered User
    Join Date
    03-10-2013
    Location
    Inverness, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Soccer league table

    Thanks Micope21,

    Works a treat. Most appreciated!

    I've clicked the star on your reply - again thanks.

    Regards,
    Iain....

+ 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