Thread: [Solved] dups
View Single Post
 
Old 07-12-2013, 08:16 AM
OCM OCM is offline Windows 7 32bit Office 2000
Novice
 
Join Date: Mar 2013
Posts: 17
OCM is on a distinguished road
Default dups

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,
Attached Files
File Type: xlsx Sample.xlsx (11.8 KB, 10 views)
Reply With Quote