I am currently using the following formula:
=IF(COUNTIF(E:E,E5)1,"Duplicate","")
Basically it is entering Duplicate in a cell if an address appears twice. My
problem is this, our HR department has changed there reports procdure. Now
one address will read 109 E. 9th St. The other address will read 109 E 9th
St. They are the same address, just missing a period. It is not being flagged
as a duplicate entry.

Is there away to look for similarities?

Thanks in advance for your time.
Steve