+ Reply to Thread
Results 1 to 6 of 6

Youth soccer tournament excel spreadsheet

  1. #1
    Registered User
    Join Date
    04-02-2019
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2010
    Posts
    3

    Youth soccer tournament excel spreadsheet

    Hi everyone,

    was wondering could someone help me with a spreadsheet to calculate results and generate tables for a youth soccer tournament I am hosting. Absolutely hopeless at this, hoping that someone can help with the formulas.

    The attached sheets just require the league tables to be finalised.

    Thanks
    Attached Files Attached Files

  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
    80,779

    Re: Youth soccer tournament excel spreadsheet

    Welcome to the forum!

    What is it exactly that you want help with? Which table are you having issues with? What have you tried so far?
    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
    04-02-2019
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2010
    Posts
    3

    Re: Youth soccer tournament excel spreadsheet

    In the results tab, I want to put the scores of the games in E4-E13 & F4-F13 (Group A), and then similar cells in the Group B,C & D.

    In the B & N cells that will be the names of the teams, which is set to copy over D,G,I & L cells when inputted.

    I am hopin that when the score goes in that it can have an effect on the 'TABLES' tab by automatically moving teams into position depending on their points tally.

    I have included another ss to show you what I mean.
    Attached Files Attached Files

  4. #4
    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
    80,779

    Re: Youth soccer tournament excel spreadsheet

    There isn't a results tab - do you mean standings?

    I am hopin that when the score goes in that it can have an effect on the 'TABLES' tab by automatically moving teams into position depending on their points tally.
    The four group tabs already do this - have you not tried entering some scores?

    Excel 2016 (Windows) 32 bit
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    3
    GROUP C
    GP
    W
    D
    L
    GF
    GA
    GD
    PTS
    4
    TEAM 1
    1
    MOYOLA JETS
    1
    1
    0
    0
    5
    1
    4
    3
    5
    GLENAVON
    2
    GLENAVON
    0
    0
    0
    0
    0
    0
    0
    0
    6
    ST MALACHYS
    3
    ST MALACHYS
    0
    0
    0
    0
    0
    0
    0
    0
    7
    MOYOLA JETS
    4
    MALAHIDE UTD
    0
    0
    0
    0
    0
    0
    0
    0
    8
    MALAHIDE UTD
    5
    TEAM 1
    1
    0
    0
    1
    1
    5
    -4
    0
    9
    RESULTS
    10
    TEAM 1
    MOYOLA JETS
    1
    :
    5
    11
    GLENAVON
    ST MALACHYS
    :
    12
    ST MALACHYS
    TEAM 1
    :
    13
    MOYOLA JETS
    MALAHIDE UTD
    :
    14
    MALAHIDE UTD
    ST MALACHYS
    :
    15
    TEAM 1
    GLENAVON
    :
    16
    GLENAVON
    MALAHIDE UTD
    :
    17
    ST MALACHYS
    MOYOLA JETS
    :
    18
    MOYOLA JETS
    GLENAVON
    :
    19
    MALAHIDE UTD
    TEAM 1
    :
    Sheet: GroupC

  5. #5
    Registered User
    Join Date
    04-02-2019
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2010
    Posts
    3

    Re: Youth soccer tournament excel spreadsheet

    Its in the attachment of the first post.
    Attached Files Attached Files

  6. #6
    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
    80,779

    Re: Youth soccer tournament excel spreadsheet

    OK, so you need to replicate the formulae in the example workbook so that they work in your new workbook.

    The idea of a help forum is to assist you in doing this, not to do it all for you, so I would ask you please to have a go yourself first. If you come unstuck, then by all means come back and ask for guidance.

+ 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. Soccer tournament 384 teams
    By daroman87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2016, 04:03 PM
  2. Excel Spreadsheet Design Help - Golf Tournament
    By MJM64 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-21-2014, 02:52 PM
  3. Tournament spreadsheet
    By Rcsprinter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2013, 05:21 AM
  4. Soccer Tournament
    By techclean in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2012, 03:03 PM
  5. Help for a soccer spreadsheet
    By fanourio in forum Excel General
    Replies: 1
    Last Post: 01-13-2011, 03:23 AM
  6. Replies: 1
    Last Post: 02-09-2005, 08:06 AM

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