Comparing List

  • Thread starter Thread starter Jim K.
  • Start date Start date
J

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.
 
Jim said:
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.
Click to expand...

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.
 
Back
Top