Extracting duplicate data from two lists

N

nikf

Hi,
I have two lists, consisting of customer ids in the form
00-00-00 ( using custom format). The first list consists
of 15,000 ids and the second one contains 500 id's. I would
like to create a third column that would consist of id's that
are in both lists.
Any help would be greatly appreciated, nikf
 
T

Tom Ogilvy

Next to either list put in the formula

=if(Countif(Sheet2!$A$1:$A$15000,A1)>0,A1,"")

then drag fill down alongside list (in the example, the list of 500 ID's).
 
Top