hi
I would delete any partial item if the partial in column B for sheets is matched with column G into sheet1
sheet1
sheet2
result
sheet1
sheet2
I would delete any partial item if the partial in column B for sheets is matched with column G into sheet1
sheet1
| (5).xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ITEM | BR | SALE | RET | LIST | ||||
| 2 | 1 | FR BANANA TT 3PP | 200 | 10 | TT | ||||
| 3 | 2 | FR 2NN APPLE LL | 100 | 20 | 3PP | ||||
| 4 | 3 | FR PEAR TTR NN | 10 | - | 2NN | ||||
| 5 | 4 | FR BANANA QQ | 20 | - | TTR | ||||
| 6 | 5 | VEG TOMATO 12/L 12TR SS | 12 | - | 12TR | ||||
| 7 | 6 | VEG TOMATO AA NN MM-2 | 12 | 12 | MM-2 | ||||
| 8 | 1-L | ||||||||
| 9 | OR-1 | ||||||||
| 10 | AA1 | ||||||||
SHEET1 | |||||||||
sheet2
| (5).xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | ITEM | BR | SALE | RET | ||
| 2 | 1 | FR PEACH 12-L TT 3PP | 1 | - | ||
| 3 | 2 | FR SRAWBERRY 1-L TTR LL | 2 | - | ||
| 4 | 3 | FR OR-1 ORANGE TTR NN | 12 | - | ||
| 5 | 4 | FR BANANA QQ | 12 | - | ||
| 6 | 5 | VEG TOMATO 12/L 12TR SS | 11 | - | ||
| 7 | 6 | VEG TOMATO AA1 NN MM-2 | 13 | 12 | ||
SHEET2 | ||||||
result
sheet1
| (5).xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | ITEM | BR | SALE | RET | ||
| 2 | 1 | FR BANANA | 200 | 10 | ||
| 3 | 2 | FR APPLE LL | 100 | 20 | ||
| 4 | 3 | FR PEAR NN | 10 | - | ||
| 5 | 4 | FR BANANA QQ | 20 | - | ||
| 6 | 5 | VEG TOMATO 12/L SS | 12 | - | ||
| 7 | 6 | VEG TOMATO AA NN | 12 | 12 | ||
SHEET1 | ||||||
sheet2
| (5).xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | ITEM | BR | SALE | RET | ||
| 2 | 1 | FR PEACH 12-L | 1 | - | ||
| 3 | 2 | FR SRAWBERRY TTR LL | 2 | - | ||
| 4 | 3 | FR ORANGE NN | 12 | - | ||
| 5 | 4 | FR BANANA QQ | 12 | - | ||
| 6 | 5 | VEG TOMATO 12/L SS | 11 | - | ||
| 7 | 6 | VEG TOMATO NN | 13 | 12 | ||
SHEET2 | ||||||
