+ Reply to Thread
Results 1 to 3 of 3

Soccer tournament 384 teams

Hybrid View

  1. #1
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Soccer tournament 384 teams

    Take a look at the attached. It handles the scheduling of the 5 matchdays and computes all of the point totals. All you would need to do is input the goals for/against for each match. I did the first two groups to demonstrate. It is all based on ROW(), so do not insert rows. You should be able to insert columns if you please, though, perhaps to add goal differential. It isn't as versatile as you requested, but it should fit your specifications. You can adjust the number of teams by increasing/decreasing the number of rows, but it's designed for groups of 6. I hope it helps!
    Attached Files Attached Files

+ 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. Football/Soccer data, teams giving up a lead or recovering a goal deficit
    By AlexCarl in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 12-11-2014, 09:15 AM
  2. Calculations on a subset of records (teams) that are tied in a tournament
    By teacherofkids in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2013, 11:06 AM
  3. [SOLVED] Two columns of teams, count the number of times the teams meet?
    By tpe102 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2013, 09:21 AM
  4. Sort and Rank teams Win Loss Draw Tally in round robin tournament
    By jammjamm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2012, 06:19 PM
  5. Soccer Tournament
    By techclean in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2012, 03:03 PM

Tags for this Thread

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