Display only "new or updated" contacts between two lists
 

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)

Display only "new or updated" contacts between two lists
 

hi
see these sites
http://www.cpearson.com/excel/duplicat.htm
http://www.cpearson.com/excel/duplic...#InOneNotOther

regards
FSt1

"Futuremathteacher" wrote:

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)