Good day!
I am trying to determine a tennis player's tie-break record (7-6 or 6-7) set score.
In the G column we have the scoreline for that respective match.
The rules are as follows:
If the value in the L column is positive (2-0, 2-1), then 7-6 means a WON tiebreak, and 6-7 means a LOST tie break
however
If the value in the L column is negative (0-2, 1-2), then 7-6 means a LOST tie break and 6-7 means a WON tiebreak
To determine if the L column is positive or negative, I am using this formula, there are many other ways but:
LEFT(L2,1)>RIGHT(L2,1)
The result that I need, is how many tie breaks (7-6, 6-7) were won and how many lost.
Probably a helper column is needed.
Have fun solving!
Bookmarks