There isn't a 3rd Worksheet -- there are only 2 Worksheets/workbooks. I want
to compare the two lists and identify any names that do not appear on the
other. Most names will be in both Workbooks, but there will be some names
that appear on one and not the other. Those missing names are the names that
I want to capture. Make sense?

"Joel" wrote:

It looks like you have a third worksheet with a complete list of names? I
would put all data on one worksheet.

Row Search List count A List B list

1
2
3

In the count column use the formula
=countif($c$2:$d$100,A1)
$c$2:$d$100 is the rqange of where you have all the names
A1 is the cell that has the name you are looking for.

copy the formul down in every cell in column B.
The entries in column b with 0 are the names that weren't found.



"Electronic Lady" wrote:

I want to compare one column on Worksheet A to another Column on Worksheet B.
Proper Names will be iin boths Columns. I'm looking for Names that are not
on both Worksheets. That is, if the name is not found on both Worksheets, I
want to capture that name/result. What can I do to obtain this? thanks!