Making a duplicate filter for 2 columns

Copper Contributor

Hello, 

 

I am trying to apply a macro to find duplicates between two columns, B and C. My current formula is 

=IF(ISERROR(MATCH(TRIM(B2),$C$2:$C$229,0)),"Unique","Duplicate")

When applied in a placeholder column, the macro does not work properly (For example 1000195 is a duplicate but shows up as unique).

 

Any solutions to resolve this problem. Also there are some duplicates within column B that I am trying to keep in the spreadsheet. 

 

Thanks, 

 

Kurtis

2 Replies

@kadam062 

The 1000195 in column B is part of a string, but the 1000195 in column C is a number. They are not the same! Change the formula in D2 to

 

=IF(ISERROR(MATCH(TRIM(B2),$C$2:$C$229&"",0)),"Unique","Duplicate")

 

and confirm with Ctrl+Shift+Enter, then fill down.

Worked like a charm. Thanks!