How to pull 1st driving per employee

[sannel23]

Hello,

I'm trying to figure out how I can pull just the 1st driving occurrence for roughly 120 drivers? Or delete every other occurrence besides the first driving event? Whichever is easiest. We need this information so we can determine how long it takes our drivers to log in, pre trip their equipment and start driving.

Thank You

DriverName	EvtTime	EvtEvent
ALCALA, OSVALDO	3:58:11​	Driving
ALCALA, OSVALDO	4:48:43​	Driving
ALCALA, OSVALDO	5:19:11​	Driving
ALCALA, OSVALDO	5:26:09​	Driving
ALCALA, OSVALDO	5:46:41​	Driving
ALCALA, OSVALDO	5:58:04​	Driving
ALCALA, OSVALDO	7:18:46​	Driving
ALCALA, OSVALDO	7:35:29​	Driving
Allen, Shawn	3:08:17​	Driving
Allen, Shawn	3:12:06​	Driving
Allen, Shawn	3:13:08​	Driving
Allen, Shawn	4:25:10​	Driving
Alvarez, Martin	2:01:21​	Driving
Alvarez, Martin	2:35:09​	Driving
Alvarez, Martin	3:15:10​	Driving
Arriaga, Herminio	6:12:11​	Driving
Arriaga, Herminio	6:49:30​	Driving
Arriaga, Herminio	7:22:44​	Driving
Arriaga, Herminio	7:40:20​	Driving
Arriaga, Herminio	8:25:55​	Driving
Arriaga, Herminio	8:36:36​	Driving
Arriaga, Herminio	9:13:04​	Driving

 

[RobP]

Hi, might this work for you ?

=LET(n,UNIQUE(A2:A23),t,XLOOKUP(n,A2:A23,B2:C23,"empty"),n&" "&t)