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)))
You just need to use MATCH() formula with wild card.
=MATCH("*"&SKU&"*",SKU-LIST,0)
Find attachment.
- Yes, this is almost what I need, but I need the opposite of that. I need to highlight unique cells (the opposite to duplicate cells) that does not match to any other even if the match is partial (if the match is partial, I do not need it to be highlighted as unique, because for me ABC1239-3 or ABC1239-4 is the same product (SKU) as ABC1239, and not unique). Thank's
