Forum Discussion
triple elim tourney
im trying to make a triple elim tourney in excel the only thing i havent figured out is how to choose a winner from the first matches and move them automatically and move the losers automatically
12 Replies
- use a if formula in each cell. if score for first match has player 1 score in A1, and player 2 in A2 then for the where the winner of that match goes do a simple if formula. so lets say winner to go to B1. youll need to add a formula for when to tell if the game is final but once known final. if(a1>a2,a1,a2)
rangelsammon how do i choose who won i need for example a5 vs a9 a5 beat a9 i need a5 to go to b7 and the loser b9 to go to b41
acemadden1975 when do you know someone won? does the winner have to get to 5 points first? if so then in b7 do below formula
if(or(a5=5,a9=5),if(a5>a9,a5,a9),””)
but if you only know the winner when final score revealed then you will need to add a cell you type final score or something so then
if(a6=“final score”,if(a5>a9,a5,a9),””)
then do same in b7 but change the a5<a9
