Forum Discussion

kadam062's avatar
kadam062
Copper Contributor
Apr 27, 2021

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 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

excel
Formulas and Functions
Macros and VBA

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 27, 2021

    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.