want to find what project is not on one list

J

jerry

I have two lists, the unique field to both lists is the text(project name).

How can I find what is not the same(meaning what is being left out)?

thanks
Jerry
 
N

Nick Hodge

Jerry

If one list is in A1:A100 on sheet1 and the other the same range on sheet2
then in B1 on sheet1 enter

=COUNTIF(Sheet2!$A$1:$A$100,A1)

Should return 0 if there are no entries in sheet2 that correspond to the
entry on sheet1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top