Spreadsheet: 842049d1694123203-get-unique-entrys-based-off-column-and-most-recent-date-sample
Sheet: Sheet1

Assigned Unit | Serial Number | Bumper Number | Inpection Date (mm/dd/yyyy) | Water container Type | Inspection status | Needs next inspection By
 | 4968 |  | 2021-03-04 00:00:00 |  | Pass | 2021-09-03 00:00:00
 | 11476 |  | 2021-03-10 00:00:00 |  | Fail | 2021-09-10 00:00:00
 | 14778 |  | 2022-02-09 00:00:00 |  | Fail | 2022-08-09 00:00:00
 | 14868 |  | 2022-02-20 00:00:00 |  | Pass | 2022-08-19 00:00:00
 | C70WT9519 |  | 2022-02-20 00:00:00 |  | Pass | 2022-08-19 00:00:00
 | 3508 |  | 2022-03-30 00:00:00 |  | Pass | 2022-09-30 00:00:00
 | 4968 |  | 2022-04-05 00:00:00 |  | Pass | 2022-10-05 00:00:00
 | 2946 |  | 2022-04-06 00:00:00 |  | Fail | 2022-10-06 00:00:00
 | 517548 |  | 2022-04-08 00:00:00 |  | Fail | 2022-10-07 00:00:00
 | 2788 |  | 2022-04-22 00:00:00 |  | Fail | 2022-10-21 00:00:00
 | 4181 |  | 2022-04-22 00:00:00 |  | Pass | 2022-10-21 00:00:00
 | 605 |  | 2022-05-04 00:00:00 |  | Pass | 2022-11-04 00:00:00
 | 3330 |  | 2022-05-04 00:00:00 |  | Fail | 2022-11-04 00:00:00
 | 517548 |  | 2022-05-06 00:00:00 |  | Fail | 2022-11-04 00:00:00
 | 486 |  | 2022-05-25 00:00:00 |  | Fail | 2022-11-25 00:00:00
 | 4575 |  | 2022-05-25 00:00:00 |  | Fail | 2022-11-25 00:00:00
 | 6290 |  | 2022-05-25 00:00:00 |  | Pass | 2022-11-25 00:00:00
 | 10590 |  | 2022-05-25 00:00:00 |  | Fail | 2022-11-25 00:00:00
 | 13985 |  | 2022-05-25 00:00:00 |  | Pass | 2022-11-25 00:00:00
 | S-4C-PWT-093 |  | 2022-05-25 00:00:00 |  | Pass | 2022-11-25 00:00:00
 | 6794 |  | 2022-06-10 00:00:00 |  | Fail | 2022-12-09 00:00:00
 | 10565 |  | 2022-06-10 00:00:00 |  | Fail | 2022-12-09 00:00:00
 | 14399 |  | 2022-06-10 00:00:00 |  | Fail | 2022-12-09 00:00:00
 | 90709 |  | 2022-06-10 00:00:00 |  | Fail | 2022-12-09 00:00:00
 | 3277 |  | 2022-06-23 00:00:00 |  | Pass | 2022-12-23 00:00:00
 | 6794 |  | 2022-06-23 00:00:00 |  | Pass | 2022-12-23 00:00:00
 | 10565 |  | 2022-06-23 00:00:00 |  | Pass | 2022-12-23 00:00:00
 | 14399 |  | 2022-06-23 00:00:00 |  | Pass | 2022-12-23 00:00:00
 | 605 |  | 2022-07-22 00:00:00 |  | Pass | 2023-01-20 00:00:00
 | 3330 |  | 2022-07-22 00:00:00 |  | Pass | 2023-01-20 00:00:00
 | 10022 |  | 2022-08-10 00:00:00 |  | Pass | 2023-02-10 00:00:00
 | 3277 |  | 2022-08-16 00:00:00 |  | Fail | 2023-02-16 00:00:00
 | 3245 |  | 2022-09-08 00:00:00 |  | Fail | 2023-03-08 00:00:00
 | 3277 |  | 2022-09-08 00:00:00 |  | Fail | 2023-03-08 00:00:00
 | 2788 |  | 2022-09-14 00:00:00 |  | Fail | 2023-03-14 00:00:00
 | 2949 |  | 2022-09-14 00:00:00 |  | Fail | 2023-03-14 00:00:00
 | 3245 |  | 2022-09-14 00:00:00 |  | Pass | 2023-03-14 00:00:00
 | 3330 |  | 2022-09-24 00:00:00 |  | Pass | 2023-03-24 00:00:00
 | 517548 |  | 2022-11-23 00:00:00 |  | Fail | 2023-05-23 00:00:00
 | 2788 |  | 2022-12-01 00:00:00 |  | Pass | 2023-06-01 00:00:00
 | 2949 |  | 2022-12-01 00:00:00 |  | Fail | 2023-06-01 00:00:00
 | 2949 |  | 2022-12-08 00:00:00 |  | Pass | 2023-06-08 00:00:00
 | 4181 |  | 2023-01-09 00:00:00 |  | Fail | 2023-07-07 00:00:00
 | 11088 |  | 2023-01-09 00:00:00 |  | Fail | 2023-07-07 00:00:00
 | 11523 |  | 2023-01-09 00:00:00 |  | Fail | 2023-07-07 00:00:00
 | 8-1063 |  | 2023-01-09 00:00:00 |  | Fail | 2023-07-07 00:00:00
 | SIAD15007 |  | 2023-01-09 00:00:00 |  | Fail | 2023-07-07 00:00:00
 | 4148 |  | 2023-02-24 00:00:00 |  | Pass | 2023-08-24 00:00:00
 | 11088 |  | 2023-02-24 00:00:00 |  | Pass | 2023-08-24 00:00:00
 | 11523 |  | 2023-02-24 00:00:00 |  | Pass | 2023-08-24 00:00:00
 | 8-1063 |  | 2023-02-24 00:00:00 |  | Pass | 2023-08-24 00:00:00
 | SIAD15007 |  | 2023-02-24 00:00:00 |  | Pass | 2023-08-24 00:00:00
 | 605 |  | 2023-03-07 00:00:00 |  | Pass | 2023-09-07 00:00:00
 | 3330 |  | 2023-03-07 00:00:00 |  | Pass | 2023-09-07 00:00:00
 | 4968 |  | 2023-03-17 00:00:00 |  | Fail | 2023-09-15 00:00:00
 | 4968 |  | 2023-03-23 00:00:00 |  | Pass | 2023-09-22 00:00:00
 | 517548 |  | 2023-03-23 00:00:00 |  | Pass | 2023-09-22 00:00:00
 | 517548 |  | 2023-04-11 00:00:00 |  | Pass | 2023-10-11 00:00:00
 | 5167 |  | 2023-04-25 00:00:00 |  | Fail | 2023-10-25 00:00:00
 | 6794 |  | 2023-05-03 00:00:00 |  | Fail | 2023-11-03 00:00:00
 | 3190 |  | 2023-06-01 00:00:00 |  | Fail | 2023-12-01 00:00:00
 | 3277 |  | 2023-06-01 00:00:00 |  | Fail | 2023-12-01 00:00:00
 | 3508 |  | 2023-06-13 00:00:00 |  | Fail | 2023-12-13 00:00:00
 | 3508 |  | 2023-06-14 00:00:00 |  | Pass | 2023-12-14 00:00:00
 | 3277 |  | 2023-06-23 00:00:00 |  | Pass | 2023-12-22 00:00:00