Hello! I have a large dataset with vehicle plates and their status = "being inspected" by date. So the dataset can look similar to this:
Plate Number Status Status Date
15787987 Inspection 01/09/2022
15787987 Inspection 02/09/2022
15787987 Inspection 03/09/2022
15787987 Inspection 04/09/2022
15787987 Inspection 05/09/2022
15787987 Inspection 01/10/2023
15787987 Inspection 02/10/2023
15787987 Inspection 10/10/2019
15787987 Inspection 11/10/2019
15787987 Inspection 12/10/2019
45484848 Inspection 04/09/2018
45484848 Inspection 05/09/2018
45484848 Inspection 01/10/2017
45484848 Inspection 02/10/2017
45484848 Inspection 13/06/2016
45484848 Inspection 14/06/2016
45484848 Inspection 15/06/2016
45484848 Inspection 16/06/2016
.
..
.
.
.
How can I get a list of plates with all the dates when they've been inspected as follows?
15787987 01/09/2022 - 05/09/2022
15787987 01/10/2023 - 02/10/2023
15787987 10/10/2019 - 12/10/2019
45484848 04/09/2018 - 05/09/2018
45484848 01/10/2017 - 02/10/2017
45484848 13/06/2016 - 16/06/2016
So far i have tried to use the formulas:
=MIN(IF(Plates!$A$1:$A$71436=$A2,Plates$C$1:$C$71436)) --> so far it has worked, but just providing the following results:
15787987 10/10/2022 - 02/10/2023
45484848 13/06/2016 - 05/09/2018
which means those vehicles have been under inspection for 2 years each...
any clues on this? thanks a lot in advance!
Laura
Bookmarks