I'm trying to automate a score sheet for volleyball. With the teams playing
a max of 3 games, I would like to place the scores into there own cells and
compute a winner by a greater than less than formula.

Say the scores are as follows:

Team 1 Team 2
25 18
17 25
14 16

W 1 2
L 2 1

I want that formula to calculate that Team 2 has 2 wins and 1 loss while
Team 1 has 1 win and 2 losses. Can this be done by using only cells (no
"condition" such as greater than 25 since the third game will only go to 15)?

Thanks.