SOLVED

Highlight unique with a partial match

Copper Contributor

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 advance2021-10-30_22-52-16.png

5 Replies

@Olejeek 

You just need to use MATCH() formula with wild card.

 

 

=MATCH("*"&SKU&"*",SKU-LIST,0)

 

 Find attachment.

 

JulianoPetrukio_0-1635697949369.png

 

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.2021-10-30_22-52-16 (2).png

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
best response confirmed by Olejeek (Copper Contributor)
Solution

@Olejeek 

Update the previous formula with ISERROR() or TYPE() formula

 

=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))

 

 

JulianoPetrukio_0-1635787349297.png

 

 

seems like this is what I need, thank you!
1 best response

Accepted Solutions
best response confirmed by Olejeek (Copper Contributor)
Solution

@Olejeek 

Update the previous formula with ISERROR() or TYPE() formula

 

=ISERROR((MATCH("*"&$B2&"*",$A$2:$A$8,0)))

 

 

JulianoPetrukio_0-1635787349297.png

 

 

View solution in original post