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
do you have onedrive? you can file > share. or upload to google drive. you should he abke to upload to thsi forum
you shared read only. make it editable.. but i see your error.. there is no score. there is also no cell to enter the score on the same line.
how is it decided who wins. score? are you going to display the score?
how is it decided who wins. score? are you going to display the score?
- 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),””),””) - https://1drv.ms/x/s!AtVDtLKTbYS3i1UAFijrWfK2kHxy?e=ZKR1Bv
maybe this link works - when i do share it says anyone can edit it
https://1drv.ms/x/s!AtVDtLKTbYS3i1UAFijrWfK2kHxy?e=lngaMD
