Thread: Filter

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

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?

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.