It's really simple to find duplicate records using SQL. Excel - not so easy
Cheers Ken From: Joseph L. Casale [mailto:[email protected]] Sent: Thursday, 3 June 2010 12:56 AM To: NT System Admin Issues Subject: RE: Excel Dupe macro @ Eric, Absolutely... @Ben, I haven't used Access, and really don't know sh!t about it, given this one time need I was hoping to avoid spending much time on it:) From: Erik Goldoff [mailto:[email protected]] Sent: Wednesday, June 02, 2010 10:33 AM To: NT System Admin Issues Subject: RE: Excel Dupe macro I'd be interested in what you turn up if you don't mind sharing Thanks Erik Goldoff IT Consultant Systems, Networks, & Security ' Security is an ongoing process, not a one time event ! ' From: Joseph L. Casale [mailto:[email protected]] Sent: Wednesday, June 02, 2010 12:11 PM To: NT System Admin Issues Subject: Excel Dupe macro Hey guys, I have a guy who was using some unknown software on his laptop that he no longer has admin right to that bollixed up his contacts in OL. So, he has ~7400 now and prolly only ~500 are valid. The issue with using tools of my choice to fix this are the few fields that contain odd characters, so I am trying to do it in excel. I found a macro to check dupes (the built in sort method crashes excel) but its removing some amount of contacts completely? Anyone got a robust macro for excel that can remove duplicate records in large datasets? Thanks! jlc ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
