I have a list of people and their ID.
I have a list of access they have, link to their ID and I can know which access they have( not the same number for each person).
Each people is in a team.
I would like to know the number of access that is common Inside a team.
The two tables are in two different sheets
In this example, for team 1, it should be 1 : 19871
I tried several things with countifs but nothing really conclusive.
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.