abdo meghari
Active Member
- Joined
- Aug 3, 2021
- Messages
- 465
- Office Version
- 2019
hi
I would delete whole item from the cells in column B where is existed two words " Purchase Order"
orginal data
result should be
thanks
I would delete whole item from the cells in column B where is existed two words " Purchase Order"
orginal data
1 (version 2).xlsb | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Sr | Description | Accepted Quantity | ||
2 | 1 | BS 1200R20 G580 TCF Purchase Order: PO-2022-00009 | 1,147 Unit | ||
3 | 2 | BS 13 R22.5 R187 Purchase Order: PO-2022-00009 | 60 Unit | ||
4 | 3 | BS 315/80 R22.5 R184 Purchase Order: PO-2022-00009 | 98 Unit | ||
5 | 4 | BS 315/80 R22.5 G580 Purchase Order: PO-2022-00009 | 20 Unit | ||
1 |
result should be
1 (version 2).xlsb | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Sr | Description | Accepted Quantity | ||
2 | 1 | BS 1200R20 G580 TCF | 1,147 Unit | ||
3 | 2 | BS 13 R22.5 R187 | 60 Unit | ||
4 | 3 | BS 315/80 R22.5 R184 | 98 Unit | ||
5 | 4 | BS 315/80 R22.5 G580 | 20 Unit | ||
1 |
thanks