How to spot new products?

[Delta223]

Hi all,

My supplier has a new product file that has new products and has closed out others. I need to:

1) Know which products have been added to the new file which are not in my current inventory file
2) Know what products have been deleted from the new inventory file (that exist in my old file)

What is the best way to do this?


PS Here is the new file:

http://utmdistributing.com/Pet_Store...preadsheet.xls

The old file matches the data format. Column A (Item ID) is a reliable way to match the items together.

[FDibbins]

1 way would be to use a vlookup in each of the tables, with a filter set to show only the "not found" entries, it should be easy to find what you need

[Delta223]

Hi, I tried to use the vlookup command but can't figure it out. I attached a sample file of SKUs, can you tell me how to compare column A (old skus) vs column B (new) for removed and new items?

Thanks for any help, I'm not very analytically oriented

[martindwilson]

try this just uses countif cannot upload at moment so in c1 put "new not found in old" and in d1 "old not found in new"
in c2 put
=IF(COUNTIF(A:A,B2),"","not found")
in d2 put
=IF(A2="","",IF(COUNTIF(B:B,A2),"","not found"))
drag both down to end of list