cdrobinson83
New Member
- Joined
- May 3, 2021
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to write something that will delete rows based on certain criteria. Based on the below, if "C" is "EXCHANGE_REPORTING_NUMBER" and "F" AND "G" are both zero, I want to delete that row and any row beneath it that shares the same details in "B" and "D". So for this case, the end result I'm looking for is for rows 2, 3, and 4 to be deleted and rows 5, 6, 7, and 8 to remain untouched. Is anyone able to help with this?
I am trying to write something that will delete rows based on certain criteria. Based on the below, if "C" is "EXCHANGE_REPORTING_NUMBER" and "F" AND "G" are both zero, I want to delete that row and any row beneath it that shares the same details in "B" and "D". So for this case, the end result I'm looking for is for rows 2, 3, and 4 to be deleted and rows 5, 6, 7, and 8 to remain untouched. Is anyone able to help with this?