I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using remove duplicates or conditionally formatting doesn’t work.
|DTS Digital Entertainment Hamilton House 2 National Technology Park|
|DTS Licenising Ltd Hamilton House 2 National Technology Park|
|DTS Licenising Ltd, Hamilton House 2National Technology Park|
|DTS Licenising LtdHamilton House 2National Technology Park|
|Hamilton House 2 National Technology Park|
Hamilton House 2 National Technology Park
This address is all for the same customer, but it shows up as 6 different addresses because of slight spelling variations.
Does anyone know of any formatting or formulas I could use to find the “similar” addresses in this column? There are over 6000 lines of data so I can not do this task manually.