2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Downtown-Bet1609
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#self-service analytics tools
#self-service analytics
#bracket
#badminton
#winner
#match
#formula
#scores
#self populates
#sets
#Excel