I have been struggling with this same type of scenario on and off for a few
months. I finally have the ultimate solution for dealing with two lists that
have matches and also potentially many differences. Insert a column to the
right of the first set of data and fill it down with the number 1. Insert a
column to the right of the second set of data and fill it down with -1. Copy
both sets of data into a new worksheet and append the sets of data so that
the 1's and -1's all line up with one another. Label the columns, calling
the column that contains the 1's and -1's "Count". Now let the Pivot Table
magic begin. Using the standard Pivot Table wizard to create a Pivot table
in some cells further to the right of where of your sets of data have been
pasted, just specify your entire range of data including the Count column.
Drag and Drop "Names" into the "Drop Row Fields Here" space on the Pivot
Table, then Drag and Drop "Count" into the "Drop Data Items Here" space on
the Pivot Table. What you end up with is 1's next to those that are in the
first list, but not in the second, 0's next to those that are in both lists,
and -1's next to those that are in the second list, but not in the first!
You have now identified all the differences between the two lists quite
easily!

"Bjarni" wrote:

Hi. I'm trying to find a function or way to compare two lists of email
addresses and see the difference between the two.

I have an email distribution list from a long time ago and one from recent
and need to know which names have been added and which names were dropped.

Can anybody help me with this? also feel free to email me at


Thanks so much for your help.