Trying to clean outlook contacts in excel....
 

I have thousands and thousands of contacts in Excel (4 files with close to
50,000 in each) probably 90 % of these are duplicated. Or nearly so...

Here is what I was trying to do...
I have created a "key" that I use CONCATENATE() to combine all fields except
catagories and notes as these 2 fields do have different data in some of the
"duplicates" that I do not want to use in the test.
I then sorted this "key, then tested with the one above. If true, then DUP
column is marked as true (then a copy and paste value to STATIC_DUP)
I then sorted by the STATIC_DUP.
This seems to work well, except... I lose the data in the catagory and notes
field in all but the first entry of that contact.


How can I mark the duplicates, yet combine all values for the enties that
are duplicate for note and catagories?


I hope this is clear enough to figure out what I am trying to do....

Thanks
Bruce