Hi,
This is my first time posting so I apologize in advance for anything I miss.
I have an Excel Spreadsheet which has about 4,000 contacts imported from about 5 different people's Outlook Contacts in my Department. A lot of the Contacts are repeated with mostly the same information except that some fields are blank or have different information in them.
Does anyone know of a formula that can be used to check for duplicate contacts and delete them while combining the different info into to a cell? Doing it all manually is a very daunting task....
Any help would be much appreciated! Thanks
-K
Bookmarks