Comparing List

[Jim K.]

I have two columns of items numbers. The first column has
35,000 entries. The second column has 39,000 entries. How
can I compare the two columns to end up with a third
column indicating what numbers in the second column are
missing from the first column.

 

[Debra Dalgleish]

Chip Pearson has instructions for tagging unique items in lists:

http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Jay]

I have two columns of items numbers. The first column has
35,000 entries. The second column has 39,000 entries. How
can I compare the two columns to end up with a third
column indicating what numbers in the second column are
missing from the first column.

Suppose the first list is in column A and the second in column B.

In C1, put:
=IF(ISERROR(VLOOKUP(B1,A:A,1,FALSE)), "missing", "-" )
and extend it downward for the length of the list.

Modify for your specific needs.