Access comes with a find duplicates query wizard or just use a query with the group by option and copy and paste to Excel
Ken On Wed, Jun 2, 2010 at 12:55 PM, Joseph L. Casale <[email protected] > wrote: > @ 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 itJ > > *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/> ~
