Spreadsheet: 772938d1647528008-extract-and-return-a-min-date-and-max-dates-extract-and-return-a-min-date-and-max-dates
Sheet: Sheet1

 |  |  |  |  |  |  | Expected Results
Date | ID | Type |  | Period | ID | Type | Min Date | [NAME] |  |  |  |  |  |  |  |  | ID | Type | Min Date | [NAME]
2019-11-01 00:00:00 | DXB-38665V | ghgh |  | [NAME] | DXB-38665V | ghgh | 2019-11-01 00:00:00 | 2019-11-10 00:00:00 |  |  | DXB-38665V | ghgh | 2019-11-01 00:00:00 | 2019-11-10 00:00:00 |  | [NAME] | DXB-38665V | ghgh | 2019-11-01 00:00:00 | 2019-11-10 00:00:00
2019-11-01 00:00:00 | 92801 | abcd |  | [NAME] | 92801 | abcd | 2019-11-01 00:00:00 | 2019-11-15 00:00:00 |  | [NAME] | 92801 | abcd | 2019-11-01 00:00:00 | 2019-11-15 00:00:00 |  | [NAME] | 92801 | abcd | 2019-11-01 00:00:00 | 2019-11-15 00:00:00
2019-11-03 00:00:00 | ESH88 | efgh |  | [NAME] | ESH88 | efgh | 2019-11-03 00:00:00 | 2019-11-16 00:00:00 |  | [NAME] | ESH88 | efgh | 2019-11-03 00:00:00 | 2019-11-16 00:00:00 |  | [NAME] | ESH88 | efgh | 2019-11-03 00:00:00 | 2019-11-16 00:00:00
2019-11-04 00:00:00 | EGR75 | ijkl |  | [NAME] | EGR75 | ijkl | 2019-11-04 00:00:00 | 2019-11-17 00:00:00 |  | [NAME] | EGR75 | ijkl | 2019-11-04 00:00:00 | 2019-11-17 00:00:00 |  | [NAME] | EGR75 | ijkl | 2019-11-04 00:00:00 | 2019-11-17 00:00:00
2019-11-05 00:00:00 | 27660 | abcd |  | [NAME] | 27660 | abcd | 2019-11-05 00:00:00 | 2019-11-05 00:00:00 |  | [NAME] | 27660 | abcd | 2019-11-05 00:00:00 | 2019-11-05 00:00:00 |  | [NAME] | 27660 | abcd | 2019-11-05 00:00:00 | 2019-11-05 00:00:00
2019-11-06 00:00:00 | 74756 | [NAME] |  | [NAME] | 74756 | [NAME] | 2019-11-06 00:00:00 | 2019-11-06 00:00:00 |  | [NAME] | 74756 | [NAME] | 2019-11-06 00:00:00 | 2019-11-06 00:00:00 |  | [NAME] | 74756 | [NAME] | 2019-11-06 00:00:00 | 2019-11-06 00:00:00
2019-11-10 00:00:00 | DXB-38665V | ghgh |  | Dec-2019 | DXB-38665V | ghgh | 2019-12-01 00:00:00 | 2019-12-10 00:00:00 |  | Dec-2019 | DXB-38665V | ghgh | 2019-12-01 00:00:00 | 2019-12-10 00:00:00 |  | Dec-2019 | DXB-38665V | ghgh | 2019-12-01 00:00:00 | 2019-12-10 00:00:00
2019-11-15 00:00:00 | 92801 | abcd |  | Dec-2019 | 92801 | abcd | 2019-12-01 00:00:00 | 2019-12-15 00:00:00 |  | Dec-2019 | 92801 | abcd | 2019-12-01 00:00:00 | 2019-12-15 00:00:00 |  | Dec-2019 | 92801 | abcd | 2019-12-01 00:00:00 | 2019-12-15 00:00:00
2019-11-16 00:00:00 | ESH88 | efgh |  | Dec-2019 | ESH88 | efgh | 2019-12-03 00:00:00 | 2019-12-16 00:00:00 |  | Dec-2019 | ESH88 | efgh | 2019-12-03 00:00:00 | 2019-12-16 00:00:00 |  | Dec-2019 | ESH88 | efgh | 2019-12-03 00:00:00 | 2019-12-16 00:00:00
2019-11-17 00:00:00 | EGR75 | ijkl |  | Dec-2019 | EGR75 | ijkl | 2019-12-04 00:00:00 | 2019-12-17 00:00:00 |  | Dec-2019 | EGR75 | ijkl | 2019-12-04 00:00:00 | 2019-12-17 00:00:00 |  | Dec-2019 | EGR75 | ijkl | 2019-12-04 00:00:00 | 2019-12-17 00:00:00
2019-12-01 00:00:00 | DXB-38665V | ghgh |  | Dec-2019 | 27660 | abcd | 2019-12-05 00:00:00 | 2019-12-05 00:00:00 |  | Dec-2019 | 27660 | abcd | 2019-12-05 00:00:00 | 2019-12-05 00:00:00 |  | Dec-2019 | 27660 | abcd | 2019-12-05 00:00:00 | 2019-12-05 00:00:00
2019-12-01 00:00:00 | 92801 | abcd |  | Dec-2019 | 74756 | [NAME] | 2019-12-06 00:00:00 | 2019-12-06 00:00:00 |  | Dec-2019 | 74756 | [NAME] | 2019-12-06 00:00:00 | 2019-12-06 00:00:00 |  | Dec-2019 | 74756 | [NAME] | 2019-12-06 00:00:00 | 2019-12-06 00:00:00
2019-12-03 00:00:00 | ESH88 | efgh
2019-12-04 00:00:00 | EGR75 | ijkl
2019-12-05 00:00:00 | 27660 | abcd
2019-12-06 00:00:00 | 74756 | [NAME]
2019-12-10 00:00:00 | DXB-38665V | ghgh
2019-12-15 00:00:00 | 92801 | abcd
2019-12-16 00:00:00 | ESH88 | efgh
2019-12-17 00:00:00 | EGR75 | ijkl