I have a spreadsheet with the scoring plays from several American Football games (Game 1 through Game 13). I want to calculate the number of lead changes.
1. The game starts off tied 0-0. When someone scores first, there is not a lead change (tied -->LA lead).
2. A lead change occurs is when one team has had a lead and the other team takes a lead (either "LA lead -->Opp lead" OR "LA lead --> tied -->Opp lead")
For example, in the photo attached, one lead changed occurred in game 2 at 34:15 when Opp took lead, and that is it.
1. The game starts off tied 0-0. When someone scores first, there is not a lead change (tied -->LA lead).
2. A lead change occurs is when one team has had a lead and the other team takes a lead (either "LA lead -->Opp lead" OR "LA lead --> tied -->Opp lead")
For example, in the photo attached, one lead changed occurred in game 2 at 34:15 when Opp took lead, and that is it.