brain fog - comparing two columns

[GuyMor]

hi all,

I need to do something that I think should be quite simple but I can't figure it out.

I have two long list of emails in two different columns.

I want to know how many emails are duplicates, or how many emails in column B, exist in column A. I don't really care which ones, just a final number

(the list is very long, in the thousands if that matters)

Thanks!

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[tanasedn]

for duplicates:

Please Login or Register  to view this content.

(if 0 then there are not duplicates)
For how many times emails from B exists in A

Please Login or Register  to view this content.

for how many times emails from A is found in B:

Please Login or Register  to view this content.

[GuyMor]

for duplicates:
For how many times emails from B exists in A

Please Login or Register  to view this content.

Doesn't this count just the one criteria = B1? I want to know ALL of the Bs that appear in column A

[GuyMor]

sample XLS attached

[TMS]

Try:

Please Login or Register  to view this content.

[tanasedn]

The formula need to be drag down. If you need to see if the email from B exist in column A. If you want to see how many from B are in A use the TMS's formula

[TMS]

@tanasedn: the OP said in the first post

I don't really care which ones, just a final number

[TMS]

@GuyMor: is this resolved?