dups

OCM · #1 07-12-2013, 08:16 AM

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,