Apr 27 2021 10:51 AM
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
Apr 27 2021 11:35 AM
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.