dups

[OCM]

Greetings,



I receive daily student registration reports in Excel 2010 format. Every now and then I’ll notice the same student is entered multiple times because of the following reasons:

Name: Joe L. Madison vs. Joseph Lance Madison
Address: Main Street vs. Main Str.
Phone #: home # vs. mobile #
E-mail address: JLM@msn.com vs. JLM@aol.com

In the attached sample document, highlighted are records that are same student but entered multiple times (because of reasons mentioned above)
What would be the best way to catch this dups? I was thinking, may be a macro to check combination of birth date + SSN + ID or any other field and if there is a match then flag as “…match found…”

Any ideas?

Regards,

[Catalin.B]

The file you attached is in a Open XML format, first introduced in office 2007.
I noticed you work with excel 2000. The easiest way is to use excel 2007 or a higher version; in the Data tab, Data tools menu, there is the option: Remove duplicates.
I suggest you use only one column, with unique ID or SSN serial numbers, to accomplish this task. In the images attached, you can see screenshots of this operation...