+ Reply to Thread
Results 1 to 7 of 7

Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    Guelph Ontario
    MS-Off Ver
    Excel 2007
    Posts
    3

    Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    HI
    Got a problem with an IF and THEN statement that hopefully a member can help me with.

    We have a tournament of 32 teams comprising of 64 people.
    They have been already assigned to separate brackets .
    I need to advance them to the next bracket if they win and a alternate bracket if they lose.
    I have a WIN/LOSS (D7/D3) field that I hoped to use with either a score(numeric) or just a simple (W) or (L)

    The problem I am running into is that the formula IF=D7>D3, C3,C7 moves players to WIN Side Bracket
    If the field (D7/D3) is blank, it will pick a winner and move them forward.

    So basically, I would like the formula only to be used if values are in the WIN/LOSS D7/D3 fields.
    I know I need a compound/nested IF statement, but just cant seem to get it right !

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    Try:
    =IF(CODE(D7)>CODE(D3),C3,C7)
    It is still excluded below info:
    If the field (D7/D3) is blank, it will pick a winner and move them forward
    Pick a winner from where and move to where?
    Quang PT

  3. #3
    Registered User
    Join Date
    02-03-2013
    Location
    Guelph Ontario
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    HI

    Thanks for the response.

    It works with a "W" and " L" input, however there is still #VALUE! showing up
    when there are no values inputted yet.

    How do I get rid of the #value! when I am waiting for an outcome of a game ?

    Thx

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    You can use IFERROR to return something if it is error
    =IFERROR(IF(CODE(D7)>CODE(D3),C3,C7),"return something if error")

  5. #5
    Registered User
    Join Date
    02-03-2013
    Location
    Guelph Ontario
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    Thanks, did the trick !

    Have a nice Weekend and thanks for the help !

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    you are welcome and thank for feedback!

  7. #7
    Registered User
    Join Date
    06-20-2014
    Location
    Oakland, CA
    MS-Off Ver
    XP
    Posts
    1

    Re: Win - Lose Bracket Tournament. Advancing Players in the excel brackets ?

    All the above was very helpful.

    We run a girls basketball tournament of 150-180 teams

    We do Pool Play day 1 and if you finish 1st, 2nd or 3rd you are placed into a Gold, Silver or Bronze bracket for day 2.

    We want it to be once the pool winners are determined to automatically be placed in to the brackets. from there once the scores are entered to automatically advance the winners.

    Currently I do everything manually and want a more seamless process.


    Help Me Please!!!

    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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