Using a Formula to Count Duplicates in two Columns

[JungleJme]

Hi,

Sorry, i am an excel novice so this is probably bread and butter to you guys!

I have two lists of names in Column A & B. I want to count how many names in Column A do NOT appear in Column B.

It seems like it should be so simple but i can't figure out a formula! I'd appreciate any help!

[daddylonglegs]

Assuming that each list runs from row 2 to row 1000 try

=SUMPRODUCT((COUNTIF(B2:B1000,A2:A1000)=0)*(A2:A1000<>""))

[JungleJme]

Thanks! Perfect!