Counting number of values from one multi-dropdown to another
Hoping someone can help me with a COUNT formula please. I have 2 multi-dropdown columns and I'm wanting to count the number of selections from one column that appear in the other.
To give a bit of context, Column 1 could have "A", "B" and "C" (but potentially many options), and Column 2 could have "A" and "B". I would like a third column to display 2, as 2 of the values from Column 1 are found in Column 2.
Essentially i'm trying to do the below to achieve the skill %, but i'm struggling with the initial part of the formula
Is this possible?
Help Article Resources
Check out the Formula Handbook template!