This formula returns all names, not just names that are missing. I'm so
confused. I have no idea what I'm doing wrong. How is this formula looking
at both worksheets? Can I put both list on one worksheet and do a compare
and find differences that way? ??

"Toppers" wrote:

Sorry .. a "dooh" moment:

Put in B1 on Sheet1:

=IF(COUNTIF(A1,Sheet2!A:A)=0,A1,"")

Put in B1 on Sheet2:

=IF(COUNTIF(A1,Sheet1!A:A)=0,A1,"")

Will now give names


"Electronic Lady" wrote:

I think I may be missing something. Where are the results posted? On what
spreadsheet? Am I supposed to link them some how? I've really no experence
with this kind of stuff. I did as you suggested, but I don't see a list of
names not found on the other spreasheet.

"Toppers" wrote:



If lists are in column of Sheet1 & Sheet2:

Put in B1 on Sheet1:

=IF(A1,Sheet2!A:A)=0),"Name not on both","")

Put in B1 on Sheet2:

=IF(A1,Sheet1!A:A)=0),"Name not on both","")


and copy down. This will list missing names.

HTH

"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!