Stumped!

[Garetht2014]

Evening all,

I have a large data set that I need to remove bits from but keep some specific data. Below is a small sample of the data (main data is 7724line). What I am trying to do is take out all the data between the first entry and the last entry for that day (all text in bold). I onty need to see the first and last entry for every day.

The data set is from our vehicle trackers so there will be mulitple entries for each driver (spreadsheet consists of 153 drivers).

Does anyone know a way this can be done ?

Registration	Start Time	End Time	Start Location	End Location
Joe Bloggs	01/07/2022 07:59​	01/07/2022 08:30​	Address	Address
Joe Bloggs	01/07/2022 08:37​	01/07/2022 08:40​	Address	Address
Joe Bloggs	01/07/2022 09:01​	01/07/2022 09:03​	Address	Address
Joe Bloggs	01/07/2022 09:41​	01/07/2022 09:46​	Address	Address
Joe Bloggs	01/07/2022 09:57​	01/07/2022 10:02​	Address	Address
Joe Bloggs	01/07/2022 10:08​	01/07/2022 10:12​	Address	Address
Joe Bloggs	01/07/2022 10:16​	01/07/2022 10:37​	Address	Address
Joe Bloggs	01/07/2022 10:40​	01/07/2022 10:45​	Address	Address
Joe Bloggs	01/07/2022 10:53​	01/07/2022 10:59​	Address	Address
Joe Bloggs	01/07/2022 11:28​	01/07/2022 12:17​	Address	Address
Joe Bloggs	01/07/2022 12:17​	01/07/2022 12:19​	Address	Address
Joe Bloggs	01/07/2022 12:29​	01/07/2022 12:40​	Address	Address
Joe Bloggs	01/07/2022 13:15​	01/07/2022 13:18​	Address	Address
Joe Bloggs	01/07/2022 13:28​	01/07/2022 13:46​	Address	Address
Joe Bloggs	01/07/2022 13:56​	01/07/2022 14:06​	Address	Address
Joe Bloggs	01/07/2022 14:25​	01/07/2022 14:27​	Address	Address
Joe Bloggs	01/07/2022 14:30​	01/07/2022 14:33​	Address	Address
Joe Bloggs	01/07/2022 14:36​	01/07/2022 14:53​	Address	Address
Joe Bloggs	01/07/2022 16:23​	01/07/2022 16:37​	Address	Address
Joe Bloggs	01/07/2022 18:27​	01/07/2022 18:31​	Address	Address
Joe Bloggs	01/07/2022 18:32​	01/07/2022 18:40​	Address	Address
Joe Bloggs	02/07/2022 11:29​	02/07/2022 11:39​	Address	Address
Joe Bloggs 1	02/07/2022 11:42​	02/07/2022 11:48​	Address	Address
Joe Bloggs 1	02/07/2022 11:57​	02/07/2022 12:04​	Address	Address
Joe Bloggs 1	02/07/2022 12:05​	02/07/2022 12:13​	Address	Address
Joe Bloggs 1	02/07/2022 12:25​	02/07/2022 12:33​	Address	Address

 

[offthelip]

You can do this by using two extra columns.
Assuming the list of date with times is in Column B
Put this in the first spare column:

=DATE(YEAR(B2),MONTH(B2),DAY(B2))

This gets rid of the times then
Then assuming the above equation was in column E
Put this is in the next spare column:

=OR(E2<>E1,E2<>E3)

You can then filter of TRUE in that column
Both equations written for row 2, then copy down