updating a win and loss column for Google Sheets

[Daniel12]

Good morning,

I have a spreadsheet for keeping up with a volleyball tournament. I need a formula to indicate whether a match was won (or lost). You must win 2 out of possible 3 sets played to win the match.

So, in this sheet, if D5>E5, and/or D6>E6, and/or D7>E7, then it would place a "1" in column J5:J7
So a team might lose the first set (D5<E5), but win the next two, that would count as a win. Or perhaps they win set 1 and 2, or set 1 and 3.

the column K5:K7 will indicate losses. this will be applied to all for teams listed.

I cant figure out the formula to use.

Thanks for the help

 

[Fluff]

Get rid of the merged cells in col J

 

[Daniel12]

I ended up creating a hidden row under each set of games to give me a count of set wins and losses for each match, then created a formula using those boxes to give me the data I needed in the overall win and loss columns.
Thanks for the input

 

[Fluff]

Glad you sorted it & thanks for letting us know.