I'm making a bracket for my badmiton team that self populates with the winner of each previous round. I'm having trouble with it populating the next bracket before all of the scores are filled out.
My computer is kinda butt so I can't take a screenshot rn sry. But basically one match looks like
| nameA | score1a | score2a | score3a |
| nameB | score1b | score2b | score3b |
Rn I have this formula, where it basically checks who won 2 of the 3 previous matches. =if((score1a>score1b)+(score2a>score2b)+(score3a>score3b)>2, nameA, nameB)
Now here's my issue: I want the cell to stay blank until all the scores are put in. rn the cell will show nameB so i was like ok lemme use some =isblank or =countblank but the problem I'm running into is it's possible to win the match in 2 sets or in 3 sets. if i say =isblank(score3a, score3b) then anyone who wins in two sets will not be populated. if i say =isblank(score 2a, score2b) once i put in the second set score then it'll show a winner and now my brain hurts.
basically im dumb, plz help. also trying to do it with smallest formula possible bc it sucks to have to change a bunch of references for each match.
[link] [comments]
Want to read more?
Check out the full article on the original site