Oct 30 2021 01:31 PM
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
Oct 31 2021 09:33 AM - edited Oct 31 2021 09:34 AM
You just need to use MATCH() formula with wild card.
=MATCH("*"&SKU&"*",SKU-LIST,0)
Find attachment.
Nov 01 2021 10:00 AM
I'm so sorry. I didn't quite clearly explain what I needed. I need to highlight unique cells in SKU's 2 column that are not in SKU's 1 column (SKU's 2 should not have duplicates in SKU's 1). But even if the match is partial, it should not be tractaded (shouldn't be highlighted) as unique, for me ABC1239-3 or ABC1239-4 is the same product (SKU) as ABC1239. In other words, I need the opposite of a function that highlights the duplicate values with a partial match.
Nov 01 2021 10:17 AM
Nov 01 2021 10:20 AM - edited Nov 01 2021 10:22 AM
SolutionUpdate the previous formula with ISERROR() or TYPE() formula
=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))
Nov 02 2021 12:00 PM
Nov 01 2021 10:20 AM - edited Nov 01 2021 10:22 AM
SolutionUpdate the previous formula with ISERROR() or TYPE() formula
=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))