I am trying to find a formula that will return values based on two cells containing similar text. I was using =IF(B1=B2,"Duplicate","") however this only highlights cells that are identical
I am trying to find a formula that will return values based on two cells containing similar text. I was using =IF(B1=B2,"Duplicate","") however this only highlights cells that are identical
If you are not aware of it MATCH, VLOOKUP and the IF(S) family of functions accept wildcards.
Does that help?
Dave
Hi,
How about: =IF(ISNUMBER(SEARCH(B1,B2)),"Duplicate","")
Define "similar"?
Can you give some examples, please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks