Forum Discussion
Making a duplicate filter for 2 columns
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 p...
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!