Hey All,
I am trying to compare two sheets, based on the same SKU and a condition (SKU to be deleted) and return only the results that are complying to the rule.
The idea is the following:
1. All the products are in the 17k products sheet
2. In the 12k products sheet are the products that were successfully imported in Wordpress
3. The 12k products sheet has in column G a "delete" indication
4. I want to compare the two sheets and return only the products that were not imported and has not to be deleted (basically, the rest of the values that I need to import).
The file is here: Work File Products.xlsx
Any ideas? Many thanks in advance,
O.
I am trying to compare two sheets, based on the same SKU and a condition (SKU to be deleted) and return only the results that are complying to the rule.
The idea is the following:
1. All the products are in the 17k products sheet
2. In the 12k products sheet are the products that were successfully imported in Wordpress
3. The 12k products sheet has in column G a "delete" indication
4. I want to compare the two sheets and return only the products that were not imported and has not to be deleted (basically, the rest of the values that I need to import).
The file is here: Work File Products.xlsx
Any ideas? Many thanks in advance,
O.