Duplicates that aren't exact.
Posted by Cyndi on January 02, 2001 2:27 PM
Hi I'm new at Excel. I have a huge list with mailing address that were entered by a number of sources and are not exact how and I find and take out the duplicates.
For example the list might have in column A-F
Alamogordo Public Schools Group Travel Partner 103 Cuba Alamogordo NM 88310
And then below that in A-F
Alamogordo Public Schools Group Travel Partner 103 Cuba Ave Alamogordo NM 88310
The only difference being the st. address in column C or it could be the name of the school that is off in column A.
Is there anything I can do?
Please Help. Thank you so much.