Need Help on formula

[Pika735]

Here is my data set, and I need to eliminate any value in Column B that doesn't corresponds to Sammy while keeping all the corresponding information in Column A and C.

For Example
I need 2033849 because it is associated with Sammy and all the other corresponding information of 5033849, and eliminate all of 5036937 information because it isn't associated with Sammy. I also want to eliminate the dates that come after Sammy. So in this case the 21st of July, I would need to eliminate any thing after that time for 2033849. I also want to eliminate anything before the last person before Sammy so it would be anything before Mary at 2021-07-21 18:19:07. Trying to get an SLA for Sammy based on the time just before him to the time he touched it Isolating those two variables.

Suzie Q	5033849	2021-07-16 13:39:51
Jo somo	5033849	2021-07-16 2:52:54
Jo somo	5033849	2021-07-16 2:51:53
James Mar	5033849	2021-07-21 20:15:35
Jon Ace	5033849	2021-07-16 1:32:24
James Mar	5033849	2021-07-21 20:33:47
Jon Ace	5033849	2021-07-16 1:32:13
Sammy G	5033849	2021-07-21 20:35:58
James Mar	5033849	2021-07-21 20:33:30
James Mar	5033849	2021-07-21 20:13:55
James Mar	5033849	2021-07-21 20:32:13
Julia H	5033849	2021-07-16 6:01:32
Mary Y	5036937	2021-07-21 18:19:07
Mary Y	5036937	2021-07-16 22:35:29
Mary Y	5036937	2021-07-16 22:37:50
Mary Y	5036937	2021-07-16 22:37:54
Mary Y	5036937	2021-07-16 22:37:59
Mary Y	5036937	2021-07-21 18:19:35
Sammy G	5036937	2021-07-21 18:20:46
Mary Y	5036937	2021-07-21 18:14:52
Mary Y	5036937	2021-07-16 21:32:07
Mary Y	5036937	2021-07-16 22:36:00

 

[daregu]

Are you still using excel 2019? Power Query could do all that for you pretty quickly.