How to extract/filter unique records from 2 lists?

I

iceman72

I have 2 lists, say List A with 300 entries and List B with 320 entries.
List A's entries are all in List B and I want to know what are the 20
different entries in List B. Short of manually eyeballing both lists,
how do I extract or filter out those 20 unique records?
 
R

Ramana Murthy

Enter this formula in C1 to see if the value in B1 is there in the list
A1:A300

=IF(ISERROR(MATCH(B1,$A$1:$A$300,0)),"Not There","There")

or,

=IF(ISERROR(VLOOKUP(B1,$A$1:$A$300,1,0)),"Not There","There")


You can copy the formula till C320 to see all the results.

Regards,
Murthy
 
Top