Update the output cells so that each row in column C shows a short code built from three parts: (1) the first two characters of the team name in column B for that same row, (2) a hyphen, and (3) the running count of that exact team name from B3 down to the current row. For example, the first time a team appears the count is 1, the second time it appears the count is 2, and so on. See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
This cell cannot be edited
Update the output cells so that each row in column C shows a short code built from three parts: (1) the first two characters of the team name in column B for that same row, (2) a hyphen, and (3) the running count of that exact team name from B3 down to the current row. For example, the first time a team appears the count is 1, the second time it appears the count is 2, and so on.