Display only "new or updated" contacts between two lists

G

Guest

I have a list of contact info in Excel format which is replaced approximately
monthly with a new file, containing new contacts. I need to send out a letter
to new contacts after each update.

Each contact list is sorted alphabetically and does not contain time/date
information for each contact.

I want to know how to display only those contacts which have been added to
the new list, so I don't have to manually go through the two lists to find
them. As secondary goals, I would also like to display any previously
existing contacts which have changed contact information.

So in logical terms, I want to see all the elements in the new set of
contacts which are not in the old set. (A/B)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to make two addresses for one person appear in filteredContacts list? 1
Sort contacts in two languages alphabetically 2
Can information be transferred between workbooks? 1
How to get Contacts to show the Distribution List they are on? 1
Contacts 2
how do I share some of my contacts and keep some private? 1
In Contacts, show distribution lists only? 2
Contacts to distribution lists 1

Top