Create counter for combinations of cell matches within same row
Hi All,
I'm trying to create a counter which identifies instances where for example "*P*" in column C and "Office" in D both occur in the same row. This counter would go in I21 in my attached screenshot.
For context, I know how to create counters, just not how to ask it to look for combinations from 2 cells within the same row.
This would obviously need to apply to the whole sheet.
I hope I've managed to explain this clearly and thanks in advance for any help!
|