[Lily]

Hi! I'm working with two different lists of inventory. The first one is a
list of inventory that a program recommends: HOWEVER, this list may have
parts that are outdated or that have been cancelled. The second list is an
updated list of ALL the available inventory our company produces, all of
which is still in production.

I'm trying to reconciliate the two lists and basically delete all products
in the first list that are not on the second list (products that have been
superseded or cancelled). The unique identifier for each product is product
number, located in Column C. Is there a way to do that in Excel? I tried
using:
=ISNUMBER(MATCH(C7,Sheet2!C:C,0))
to see if the part numbers in sheet one are in sheet 2, and it gave me
"TRUE/FALSE" entries. This method might work, but is there an easy way to
delete all "FALSE" entries? Or is there a whole different approach that might
be easier/more practical for such huge files?

[Mike H.]

If you then sort on the column that has the true/false you'll have all your
false ones together and can easily delete them.

"Lily" wrote:

Hi! I'm working with two different lists of inventory. The first one is a
list of inventory that a program recommends: HOWEVER, this list may have
parts that are outdated or that have been cancelled. The second list is an
updated list of ALL the available inventory our company produces, all of
which is still in production.

I'm trying to reconciliate the two lists and basically delete all products
in the first list that are not on the second list (products that have been
superseded or cancelled). The unique identifier for each product is product
number, located in Column C. Is there a way to do that in Excel? I tried
using:
=ISNUMBER(MATCH(C7,Sheet2!C:C,0))
to see if the part numbers in sheet one are in sheet 2, and it gave me
"TRUE/FALSE" entries. This method might work, but is there an easy way to
delete all "FALSE" entries? Or is there a whole different approach that might
be easier/more practical for such huge files?