Spreadsheet: 789300d1659030543-fine-earliest-date-based-on-multiple-criteria-earliest-date-query
Sheet: Sheet1

SID NO | ID | PI | ActionDate-new | Earliest Date | Required Result | Earliest Date | Latest Date
S1 | 13 | SH047 | 2022-06-30 17:06:00
S1 | 39 | SH001 | 2022-07-02 14:22:00
S1 | 39 | SH001 | 2022-07-02 22:03:00
S1 | 39 | [NAME] | 2022-07-02 22:03:00
S1 | 13 | SH001 | 2022-07-03 05:26:00 | 2022-07-03 05:26:00 | 2022-07-03 05:26:00 | 2022-07-03 05:26:00 | 2022-07-03 05:26:00
S1 | 13 | SH003 | 2022-07-03 10:43:00
S1 | 39 | SH005 | 2022-07-03 16:38:00
S10 | 39 | SH001 | 2022-07-03 04:56:00
S10 | 13 | SH001 | 2022-07-06 07:33:00 |  |  |  | 2022-07-06 07:33:00
S10 | 39 | SH001 | 2022-07-06 06:11:00
S10 | 39 | SH001 | 2022-07-06 07:31:00
S10 | 39 | SH001 | 2022-07-06 06:11:00
S10 | 13 | SH001 | 2022-07-06 07:31:00 | 2022-07-06 07:31:00 | 2022-07-06 07:31:00 | 2022-07-06 07:31:00
S10 | 39 | SH001 | 2022-07-06 06:11:00
S11 | 2433 | SH047 | 2022-07-01 20:40:00
S11 | 13 | SH047 | 2022-07-02 09:38:00
S11 | 13 | SH001 | 2022-07-02 07:00:00 |  |  |  | 2022-07-02 07:00:00
S11 | 657 | SH003 | 2022-07-04 08:20:00
S11 | 657 | SH005 | 2022-07-04 09:50:00
S11 | 2433 | SH047 | 2022-06-29 21:31:00
S11 | 13 | SH047 | 2022-06-30 04:18:00
S11 | 13 | SH001 | 2022-06-30 05:07:00 | 2022-06-30 05:07:00 | 2022-06-30 05:07:00 | 2022-06-30 05:07:00
S12 | 39 | SH001 | 2022-07-03 13:42:00
S12 | 738 | SH001 | 2022-07-06 07:46:00
S12 | 13 | SH001 | 2022-07-07 00:17:00 |  | 2022-07-07 00:17:00
S12 | 8152 | SH003 | 2022-07-07 08:14:00
S12 | 13 | SH001 | 2022-07-07 10:54:00 |  |  |  | 2022-07-07 10:54:00
S12 | 30985 | SH047 | 2022-06-28 14:07:00
S12 | 13 | SH047 | 2022-06-30 16:49:00
S12 | 13 | SH001 | 2022-06-30 16:57:00 | 2022-06-30 16:57:00 |  | 2022-06-30 16:57:00
S13 | 39 | [NAME] | 2022-07-03 06:29:00
S13 | 39 | SH001 | 2022-07-03 06:29:00
S13 | 39 | SH001 | 2022-07-04 01:37:00
S13 | 39 | SH003 | 2022-07-04 10:42:00
S13 | 39 | SH005 | 2022-07-04 12:30:00
S13 | 588 | SH047 | 2022-06-24 11:37:00
S13 | 588 | SH047 | 2022-06-24 14:57:00
S13 | 13 | SH001 | 2022-07-01 08:22:00 | 2022-07-01 08:22:00 | 2022-07-01 08:22:00 | 2022-07-01 08:22:00 | 2022-07-01 08:22:00
S14 | 39 | SH001 | 2022-07-02 20:28:00
S14 | 39 | [NAME] | 2022-07-02 20:28:00
S14 | 39 | SH003 | 2022-07-17 08:39:00
S14 | 39 | SH005 | 2022-07-17 12:26:00
S14 | 13 | SH047 | 2022-06-30 04:24:00
S14 | 13 | SH047 | 2022-06-30 04:55:00
S14 | 722 | SH001 | 2022-07-06 09:57:00
S14 | 722 | SH003 | 2022-07-22 13:06:00
S15 | 722 | SH005 | 2022-07-22 14:08:00
S15 | 13 | SH047 | 2022-06-21 13:31:00
S15 | 13 | SH047 | 2022-06-21 13:27:00
S15 | 39 | SH001 | 2022-07-08 06:01:00
S15 | 39 | [NAME] | 2022-07-08 06:01:00
S15 | 39 | SH001 | 2022-07-08 15:47:00
S15 | 39 | SH003 | 2022-07-12 07:41:00
S15 | 39 | SH005 | 2022-07-12 14:03:00
S15 | 13 | SH001 | 2022-07-01 06:28:00 | 2022-07-01 06:28:00 | 2022-07-01 06:28:00 | 2022-07-01 06:28:00 | 2022-07-01 06:28:00
S2 | 13 | SH047 | 2022-06-30 17:36:00
S2 | 39 | SH001 | 2022-07-02 14:23:00
S2 | 39 | SH001 | 2022-07-02 15:36:00
S2 | 738 | SH001 | 2022-07-03 10:20:00
S2 | 1155 | SH001 | 2022-07-08 09:37:00
S2 | 1155 | SH003 | 2022-07-12 10:20:00
S2 | 1155 | SH005 | 2022-07-12 10:24:00
S2 | 1155 | SH001 | 2022-07-25 09:23:00
S3 | 39 | SH001 | 2022-07-02 14:20:00
S3 | 13 | SH001 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00
[NAME] | 39 | SH001 | 2022-07-02 14:23:00
[NAME] | 39 | SH001 | 2022-07-02 15:36:00
[NAME] | 39 | SH001 | 2022-07-02 14:23:00
[NAME] | 39 | SH001 | 2022-07-02 14:20:00
S5 | 39 | SH001 | 2022-07-02 15:39:00
S5 | 39 | SH001 | 2022-07-02 14:20:00
S5 | 13 | SH001 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00 | 2022-07-02 15:39:00
S5 | 39 | SH001 | 2022-07-02 14:23:00
S5 | 39 | SH001 | 2022-07-03 04:56:00
S6 | 13 | SH001 | 2022-07-03 04:54:00
S6 | 39 | SH001 | 2022-07-03 05:35:00
S6 | 39 | SH001 | 2022-07-03 04:56:00
S6 | 39 | SH001 | 2022-07-03 04:56:00
S6 | 13 | SH001 | 2022-07-03 04:48:00 | 2022-07-03 04:48:00 | 2022-07-03 04:48:00 | 2022-07-03 04:48:00
S6 | 39 | SH001 | 2022-07-03 05:35:00
S6 | 39 | SH001 | 2022-07-03 04:54:00
S6 | 39 | SH001 | 2022-07-03 04:54:00
S6 | 13 | SH001 | 2022-07-03 05:35:00 |  |  |  | 2022-07-03 05:35:00
S7 | 39 | SH001 | 2022-07-03 04:18:00
S7 | 39 | SH001 | 2022-07-03 04:55:00
S7 | 39 | SH001 | 2022-07-03 04:18:00
S7 | 13 | SH001 | 2022-07-03 04:55:00 |  |  |  | 2022-07-03 04:55:00
S7 | 13 | SH001 | 2022-07-03 04:18:00 | 2022-07-03 04:18:00 | 2022-07-03 04:18:00 | 2022-07-03 04:18:00
S7 | 39 | SH001 | 2022-07-03 04:56:00
S8 | 39 | SH001 | 2022-07-03 04:18:00
S8 | 13 | SH001 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00
S8 | 39 | SH001 | 2022-07-03 04:56:00
S8 | 39 | SH001 | 2022-07-03 04:18:00
S8 | 13 | SH001 | 2022-07-03 04:56:00 |  |  |  | 2022-07-03 04:56:00
S9 | 39 | SH001 | 2022-07-03 04:54:00
S9 | 39 | SH001 | 2022-07-03 04:18:00
S9 | 13 | SH001 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00 | 2022-07-03 04:55:00
S9 | 39 | SH001 | 2022-07-08 23:30:00
S9 | 39 | SH001 | 2022-07-09 00:18:00
S9 | 13 | SH001 | 2022-07-03 04:56:00 |  |  |  | 2022-07-03 04:56:00