bythecshore
Board Regular
- Joined
- Feb 4, 2009
- Messages
- 66
- Office Version
- 365
- Platform
- MacOS
I have two columns of company names. I want to find names that exist in both (duplicates). But I also need to have partial matches, so that a "Hilton" in column A shows as a duplicate for "Hilton Garden" in column B.
I got part of the way there using the duplicate function in conditional formatting, but I didn't get the partial matches, unless I did it wrong.
Thanks in advance!
I got part of the way there using the duplicate function in conditional formatting, but I didn't get the partial matches, unless I did it wrong.
Thanks in advance!