Forum Discussion
Solved
Highlight unique with a partial match
Hello, I need to find and highlight unique values, even those that match partially in two columns. I have attached a screenshot to show what I mean. Thank you in advance
Update the previous formula with ISERROR() or TYPE() formula
=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))
Update the previous formula with ISERROR() or TYPE() formula
=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))
seems like this is what I need, thank you!