list duplicates

A

Abbie

hi,

not sure if this is possible, but i need to de-duplicate a list from another
list...

I have:
List A - a list of all the people i have contacted
List B - a list of all the people i have contacted AND several that i have not

i want to know if there is an easy way to find people that are on list B,
but not on list A...

The advanced filters for deduplicating records only give me a complete list
B as they do not remove both entries of the duplicate!

Help!
 
S

Sean Timmons

In, say, column E:

=IF(COUNTIF(A:A,C2)>0,"","Not on list A")

Assuming list a is in column A and list b is in column C.
 
M

muddan madhu

try this
list A is Col A & list B is in Col B
Col C put this formula and drag it down

=IF(ISNA(MATCH(B2,$A$2:$A$25,0)),"Not in List A","contacted")
 
Top