Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Contacts from Excel to Outlook | Excel Discussion (Misc queries) | |||
How do I export contacts from Excel back to Outlook Contacts? | Excel Discussion (Misc queries) | |||
export from 07 excel to outlook contacts | Excel Worksheet Functions | |||
Invoke Outlook Contacts From Within Excel | Excel Programming | |||
How do I share excel contacts with outlook? | Excel Discussion (Misc queries) |