I have a list of teams that all have a number.
I have a function that determines the common values of each team.
I need to find a way for this function to automatically detect when the team number changes.Obviously, mine is longer and have tens of rows
I tried to use an If formula with something like =IF ( A2<>A3; … ) but I don’t think this is the way and I don’t know how to use VBA and macro
New contributor
Boivin12 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.