Notifications
Clear all
Topic starter
I have an Excel file with 2 columns containing addresses (data on sheet 2). I want to compare the columns and point out the differences. I tried to use conditional formatting but its not working. Can someone please help. Thanks
Posted : 26/12/2021 11:56 am
A couple of issues with your data. One is all caps while the other is initial caps. These are not matches. Additionally, once I capitalize all there are trailing spaces in some, so I trimmed them both. I did this all in Power Query and then merged (Full outer join) to determine the differences. You can see all this in the attached file.
Posted : 26/12/2021 8:24 pm
i would use match, but i assume you will need to do a 2 way match
=MATCH(TRIM(A2),TRIM(C:C),0)
Posted : 26/12/2021 8:31 pm
