Hi,

I have a spreadsheet with hundreds of addresses in two different columns.
There are duplicates in the second column of the data and I would like to
locate and delete them. Some of the duplicate addresses are not exact
matches. For example, the street name in the first column may be in caps and
the one in second column might not be. Is there a function that can locate
similar to exct addresses in another column.

Thank You,