I have a spreadsheet of football scoring plays. I want to number the scores by team.
Column A is the year (the spreadsheet has a few decades of scoring plays)
Column B is the game number of the year in Column A
Column C is the team scoring (L is one team, O is the opponent, while Game shows when a game starts and ends)
In column D, I numbered the scoring play. So D3 was L's first score, then D5 is the second, D6 is the third. I need a formula to do this automatically please!
Column A is the year (the spreadsheet has a few decades of scoring plays)
Column B is the game number of the year in Column A
Column C is the team scoring (L is one team, O is the opponent, while Game shows when a game starts and ends)
In column D, I numbered the scoring play. So D3 was L's first score, then D5 is the second, D6 is the third. I need a formula to do this automatically please!