I have a list of names in Column R on Sheet1. There are multiple names in each cell and they are separated by a semi colon.
I have a list of names in Column A on Sheet2. There are single entries in each cell.
Is there a way for me to lookup the names in Column A of Sheet2 against Column R on Sheet1 and record a count of how many match?
For example: R2 on Sheet1 has 8 names, each separated by ;
2 of these names exist in Column A on Sheet2, so S2 on Sheet1 will record a value of 2
Thanks in advance
I have a list of names in Column A on Sheet2. There are single entries in each cell.
Is there a way for me to lookup the names in Column A of Sheet2 against Column R on Sheet1 and record a count of how many match?
For example: R2 on Sheet1 has 8 names, each separated by ;
2 of these names exist in Column A on Sheet2, so S2 on Sheet1 will record a value of 2
Thanks in advance
