Filter

[shadow91]

Okay, this may be confusing, but I will do my best to explain it...

I have a spreadsheet with data for about 12,000 products. I have a separate spreadsheet listing discontinued products (there happens to be quite a handful of them too). Not all of the discontinued products are in my spreadsheet, because I have a slightly up to date version, but some of them are. Is there a way that I can delete the discontinued products from my database without having to sort them by hand (that could take countless hours)? Another factor: the discontinued list only has the sku, or, the first column. But my spreadsheet has several columns of information after the sku, and for every discontinued product, I need to remove the entire row.

This may not be possible, and if not that is okay, but it would also help if I could actually extract the discontinued rows from the data for another spreadsheet, rather than just deleting them.

Any help on this would be highly appreciated.

Thanks,
Matt

[ChemistB]

Let's say your products are on sheet1 and discontinued on sheet2. The sku is in column A of both sheets starting in A2.
First, insert a new column before A on sheet1 (moving sku to col B). In A2,dragged down
=ISNUMBER(MATCH(B2,sheet2!$A$2:$A200,0)),"Y","N")
This gives a "Y" in every row that is discontinued.
Filter on "Y" and delete those rows. Does this work for you?

[shadow91]

I get a return message that says, "The formula you typed contains an error."

I'm not really sure how to troubleshoot this problem.

Any help?

[shadow91]

Oh, I figured out my problem! Thank you so much, I wouldn't have known where to start. You don't know how much time you have saved! Much appreciated.