Myrna,

Also, if I understand your code correctly, I don't think it is going to give me the numbers I'm looking for.
Example:
Row3 contains the following names. James, Mike, Mike, Jeff, James. Where Mike and Jeff are in the list in sheet2 and James is not. The code should yeild 2 names in the list, 1 name not in the list and 3 people total.

Erik