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
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
- i just want to pick the winner from each match and have thm move to the correct cell when i enter the formula it just shows an error with the word name in it
- provide a link to your shared file or attach
rangelsammon how do attach it so you can see im still a little new to this