2 Columns - Want To Count Number of Non Duplicates

Hi There,

I am trying to compare two lists to count the number of times the second list is missing information in the first column.

I have been playing with formulas but I am a bit lost.

I'm sure its not difficult and I am just missing something.

What formula would accomplish this?

First column is 845 cells in length, second is 665 if that matters.

Les

It's hard to give you something specific without seeing a sample book, but it sounds like an easy solution might be to use a helper column and COUNTIF. If your first list is in A2:A846 and your second list is in B2:B666, then in C2 try the following:

=IF(COUNTIF($A$2:$A$846, $B2)=0, "Not in A", "In A")

This will return "Not in A" if B2 is not included in the list in A. Fill it down through C666 to get all the non-matches, then use a COUNTIF formula on column C to get your totals. If I have the columns backwards, then just switch the As and Bs in the formula. Hopefully this helps?

Glad to help, good luck!