Try www.mrexcel.com The Forums. Jim
On 6/2/10 9:11 AM, Joseph L. Casale wrote: > > 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/> ~