floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
I'm not sure this is even possible, but I will try to explain the best I can.
I have a data set that lists Sent and Opened messages. The rows are sorted so they appear like below:
Message 1 Sent 7/11/2022
Message 1 Opened 7/11/2022
Message 2 Sent 7/12/2022
Message 2 Opened 7/12/2022
Message 2 Opened 7/13/2022
Message 3 Sent 7/14/2022
Message 3 Sent 7/14/2022
So, for example message 1 was sent and opened. Message 2 was sent and shows opened 2 times. Message 3 was sent but not opened. Also the messages can be sent to more than 1 recipient which is why message 3 shows sent 2 times.
If a message was opened 2 times, like message 2, I want to get rid of the duplicate row. I can't do remove duplicates because then message 3 would get removed because it was sent 2 times.
Is there a way to remove a row if the row above it contains the same criteria? Like if Row 5 shows opened, and row 4 shows opened, then delete row 5?
I hope this makes sense. I'm not even sure anything like this is possible, but thought I would ask.
I have a data set that lists Sent and Opened messages. The rows are sorted so they appear like below:
Message 1 Sent 7/11/2022
Message 1 Opened 7/11/2022
Message 2 Sent 7/12/2022
Message 2 Opened 7/12/2022
Message 2 Opened 7/13/2022
Message 3 Sent 7/14/2022
Message 3 Sent 7/14/2022
So, for example message 1 was sent and opened. Message 2 was sent and shows opened 2 times. Message 3 was sent but not opened. Also the messages can be sent to more than 1 recipient which is why message 3 shows sent 2 times.
If a message was opened 2 times, like message 2, I want to get rid of the duplicate row. I can't do remove duplicates because then message 3 would get removed because it was sent 2 times.
Is there a way to remove a row if the row above it contains the same criteria? Like if Row 5 shows opened, and row 4 shows opened, then delete row 5?
I hope this makes sense. I'm not even sure anything like this is possible, but thought I would ask.