I want to compare columns A and B, row by row, where values in B might contain substrings of A.
How can I count the number of substring matches ("am" in hamster, "bit" in rabbit, "us" in mouse and "squirrel" in squirrel) with a formula? (Do not want to use column C at all to indicate if each row is a match or not)
I guess I have to use countifs or sumproduct? But don't know how to do it in this specific case.
How can I count the number of substring matches ("am" in hamster, "bit" in rabbit, "us" in mouse and "squirrel" in squirrel) with a formula? (Do not want to use column C at all to indicate if each row is a match or not)
I guess I have to use countifs or sumproduct? But don't know how to do it in this specific case.
Last edited: