+ Reply to Thread
Results 1 to 2 of 2

Creating a Tournament Bracket in Excel 2010

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    nowhere
    MS-Off Ver
    Excel 2003
    Posts
    1

    Creating a Tournament Bracket in Excel 2010

    I'm trying to create a bracket for video game tournaments and I'm having trouble with some of the functionality I want it to have.

    Right now, I have cells B7 and B9 that will pull player names from another check in sheet. I have another cell, D8, that I would like to have a drop down list in containing the contents of B7 and B9. Everything I see online says to use Data Validation, but apparently that tool can't make a list using cells that aren't next to each other, so that won't work. How else can I tell excel how to populate this list? It is vital that the cells be apart from each other because the visual formatting is necessary for displaying the bracket on a projector so that the players can see their match assignments.

    In addition, I would like to have another drop down menu in another cell with a list of valid bracket sizes (4, 8, 16, 32, etc.), and have the cells of the sheet either be visible or invisible depending on how many max players can enter. In other words, if columns B, D, F, and H correspond to the number of rounds it will take to finish the tournament (3, 2, 1, and 0, respectively), I would like the sheet to display only the cells necessary for the tournament, pull player names into the left most cells needed from another worksheet used for sign ups, and auto populate all of the columns to the right of the column for first round with drop down lists for the players who could have won that match in the previous round.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Creating a Tournament Bracket in Excel 2010

    can you draw ideas from this?
    http://dailydoseofexcel.com/archives...tion-brackets/

    it shows how the DV works
    your DV should actually draw from information on the side/below the actual bracket

    Re:bracket size
    better off just having different template sheets than having a DV control the bracket size
    if gets too complicated having all brackets represented on a single sheet
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 8
    Last Post: 08-23-2018, 04:21 PM
  2. Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?
    By Robbo315 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2014, 02:47 PM
  3. Bracket or Tournament Help
    By rogeru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2011, 02:11 PM
  4. Bracket Tournament help
    By Ziggy_Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2010, 10:29 AM
  5. how to create a tournament bracket in excel
    By Erik in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-11-2005, 06: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