Hi all,
I’ve been battling with this for few days and wondered if anyone could help.
I have two columns ‘Code A’ and ‘Code B’ with some of the values on their own and some ‘combined’ with “/”. What I want (in column D) is to look at the code in column A and, if there is a match for it in column B (either on its own or within combined string), print it in column D (so in effect, I’m looking for duplicates).
I’d rather try formulas first and not VBA if at all possible.
Any help much appreciated. Thanks!
Bookmarks