+ Reply to Thread
Results 1 to 4 of 4

Need Help with Soccer Table (please)

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Need Help with Soccer Table (please)

    Hi Guys,

    I'm tryiong to put together a soccer table together for me and my mates.
    I have figured how to get the results for Goals Against vs Goals For & Goal Difference

    But I cant seem to work out of the rest, what I am trying to do enable on the spreadsheet is.

    When someone plays a game it will automatically upload in the games played field, and depending on the result they will get a W , D or L which will equals 3 for win , 1 for draw and 0 for loss

    Pretty much a basic soccer table, but it's so hard to put together.

    Any help will be highly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,057

    Re: Need Help with Soccer Table (please)

    Not with this approach.

    First you need to use team names instead of pictures.
    Then it would be easier to place Match Days in each new row.
    Never use Merged Cells in Excel

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,057

    Re: Need Help with Soccer Table (please)

    Here is example:
    Attached Files Attached Files

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Need Help with Soccer Table (please)

    hi hikiertan, welcome to the forum. I have done up a fixture table on the right for you, which is more suitable to pick up scores. you can base on that & beautify it. 1 thing to take note. Do not put spaces in the club names to adjust it to a place you want to show. use the indent instead.
    Attached Files Attached Files

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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