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
https://1drv.ms/x/s!AtVDtLKTbYS3i1UAFijrWfK2kHxy?e=ZKR1Bv
maybe this link works
maybe this link works
winners side
=iferror(if(or(a5=3,a9=3),if(a5>a9,a5,a9),””),””)
same for losers side but = 2 instead of 5
but a5 or a9 will be the score cell. so if thats currently the team name then you will need a new cell to use. maybe for the team on a5 you place the score in b5. same for a9 use b9 for score
=iferror(if(or(b5=3,b9=3),if(b5>b9,a5,a9),””),””)
=iferror(if(or(a5=3,a9=3),if(a5>a9,a5,a9),””),””)
same for losers side but = 2 instead of 5
but a5 or a9 will be the score cell. so if thats currently the team name then you will need a new cell to use. maybe for the team on a5 you place the score in b5. same for a9 use b9 for score
=iferror(if(or(b5=3,b9=3),if(b5>b9,a5,a9),””),””)