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/> ~
