I have two lists of customers for 2006 and 2007. I want to compare
these two to see which ones match and which ones are lost and how many
new ones we acquired.

The format is:

Customer Name(2007) Customer Name(2006)
A A
B C
C D

The list is about 30,000 names. I already did a sort on the two lists
but I am having trouble figuring out how many we retained, how many we
lost and how many we acquired.

Thanks

RB