Subtract one list from another

  • Thread starter Thread starter Bill Y
  • Start date Start date
B

Bill Y

Hello,

I have two lists, the first containing all possible items, and the second
containing less than all items. Values are text.

I want to know what items in the first list are not found in the second
list. In other words, I want to subtract the second from the first.

Any ideas?

Bill
 
Bill,

You can use VLOOKUP:

To the side of each item in list1 (I put it in column A),
write:
=VLOOKUP(A1,list2,1,0)
drag down the formula.

You can then filter the data to remove all = or <> #N/A

HTH,
Felipe
 
One way to do this

If your first list is on sheet 1 in cells A1:A1000 and you second list
on sheet 2 in cells A1:A500 etc

On sheet 1 in cell B1 enter =COUNTIF(Sheet2!$A$1:$A$500,A1)

copy this formula to the rest of column B, this will count all entries
on sheet 2

Perform a sort of columns A:B on sheet1 and delete all rows with a
count of 1 or more, leaving all zero rows i.e. items with no entries on
sheet2

Hope this helps

Mike
 
Back
Top