Remove duplicates if

[afountas]

I have a list of 1500 addresses, some of which repeat. However a simple remove duplicates does not work perfectly becasue of slight variances in addresses.

i.e. 100 Oak St. OR 100 Oak St OR 100 Oak Street


All 3 values will remain.

Is there a formula that could delete cells with x or more of the same characters.

.. basically: remove cells in range containing "7" identical characters

Any ideas

 

[Robert Mika]

You can try to use the SEARCH function to find if your cells contain the same characters.