Spreadsheet: 693960d1599231571-return-most-recent-occurrence-in-list-based-on-multiple-array-criteria-return-most-recent-occurrence-in-list-based-on-multiple-array-criteria
Sheet: Sheet2

Table 1 |  |  |  |  |  | Table 2
Title | Subchapter | Page | Date | Time |  | String | Title | Subchapter | Page | Date + Time of first occurrence | Date + Time of last occurrence
Title001 | Subchapter001 | Page001 | 2020-03-25 00:00:00 | 14:43:00 |  |  |  |  |  |  | 2020-03-25 14:43:00 | 2020-03-25 14:43:00
Title002 | Subchapter002 | Page002 | 2020-03-25 00:00:00 | 14:43:06 |  | Title002 | Subchapter002 | Page002 | Title002 | Subchapter002 | Page002 | 2020-03-25 14:43:06 | 2020-03-27 11:04:40 | 2020-03-27 11:04:40
Title003 | Subchapter003 | Page001 | 2020-03-25 00:00:00 | 14:39:07 |  | Title003 | Subchapter003 | Page001 | Title003 | Subchapter003 | Page001 | 2020-03-25 14:39:07 | 2020-03-27 10:19:33 | 2020-03-27 10:19:33
Title004 | Subchapter001 | Page002 | 2020-03-25 00:00:00 | 14:39:29 |  | Title004 | Subchapter001 | Page002 | Title004 | Subchapter001 | Page002 | 2020-03-25 14:39:29 | 2020-03-27 10:19:02 | 2020-03-27 10:19:02
Title005 | Subchapter002 | Page003 | 2020-03-25 00:00:00 | 14:40:38 |  | Title005 | Subchapter002 | Page003 | Title005 | Subchapter002 | Page003 | 2020-03-25 14:40:38 | 2020-03-27 10:19:35 | 2020-03-27 10:19:35
Title006 | Subchapter003 | Page001 | 2020-03-25 00:00:00 | 14:40:48 |  | Title006 | Subchapter003 | Page001 | Title006 | Subchapter003 | Page001 | 2020-03-25 14:40:48 | 2020-03-27 10:19:02 | 2020-03-27 10:19:02
Title007 | Subchapter001 | Page003 | 2020-03-25 00:00:00 | 14:40:51 |  | Title007 | Subchapter001 | Page003 | Title007 | Subchapter001 | Page003 | 2020-03-25 14:40:51 | 2020-03-25 14:40:51 | 2020-03-25 14:40:51
Title008 | Subchapter002 | Page001 | 2020-03-25 00:00:00 | 14:41:47 |  | Title008 | Subchapter002 | Page001 | Title008 | Subchapter002 | Page001 | 2020-03-25 14:41:47 | 2020-03-27 10:19:02 | 2020-03-27 10:19:02
Title006 | Subchapter003 | Page001 | 2020-03-27 00:00:00 | 10:10:32
Title004 | Subchapter001 | Page002 | 2020-03-27 00:00:00 | 10:10:49
Title005 | Subchapter002 | Page003 | 2020-03-27 00:00:00 | 10:18:11 |  |  |  | Subchapter001 | Page001 |  | 2020-03-25 14:43:00
Title006 | Subchapter003 | Page001 | 2020-03-27 00:00:00 | 11:04:39 |  |  | Title002 | Subchapter002 | Page002 | 2020-03-25 14:43:06 | 2020-03-27 11:04:40
Title002 | Subchapter002 | Page002 | 2020-03-27 00:00:00 | 11:04:40 |  |  | Title003 | Subchapter003 | Page001 | 2020-03-25 14:39:07 | 2020-03-27 10:19:33
Title003 | Subchapter003 | Page001 | 2020-03-27 00:00:00 | 10:19:33 |  |  | Title004 | Subchapter001 | Page002 | 2020-03-25 14:39:29 | 2020-03-27 10:19:02
Title004 | Subchapter001 | Page002 | 2020-03-27 00:00:00 | 10:19:35 |  |  | Title005 | Subchapter002 | Page003 | 2020-03-25 14:40:38 | 2020-03-27 10:19:35
Title005 | Subchapter002 | Page003 | 2020-03-27 00:00:00 | 10:19:35 |  |  | Title006 | Subchapter003 | Page001 | 2020-03-25 14:40:48 | 2020-03-27 10:19:02
Title008 | Subchapter002 | Page001 | 2020-03-27 00:00:00 | 10:19:02 |  |  | Title007 | Subchapter001 | Page003 | 2020-03-25 14:40:51 | 2020-03-25 14:40:51
Title006 | Subchapter003 | Page001 | 2020-03-27 00:00:00 | 10:19:02 |  |  | Title008 | Subchapter002 | Page001 | 2020-03-25 14:41:47 | 2020-03-27 10:19:02
Title004 | Subchapter001 | Page002 | 2020-03-27 00:00:00 | 10:19:02