firmament1987
New Member
- Joined
- Apr 24, 2020
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
i did a for loop if column Purchase item contains "Apple" it will delete it and move on however i want it to also delete all item within customer A not just his "apple" row leaving behind banana row and pear row
so outcome will be only customer C - Papaya and Customer D - pineapple will remain all other rows will be deleted
Please help thanks in advance
so outcome will be only customer C - Papaya and Customer D - pineapple will remain all other rows will be deleted
Please help thanks in advance
Name | Purchased item |
Customer A | Apple |
Customer A | Banana |
Customer A | Pear |
Customer B | Apple |
Customer C | Papaya |
Customer D | Pineapple |