Spreadsheet: 740922d1626702050-index-match-and-max-formula-example-formulas
Sheet: Sheet1

 |  | Test5 |  |  |  |  |  | 2021-06-25 16:12:38 |  |  |  | Test1 |  |  | < this should be 7/12/21 (cell I58) |  |  |  | Column N should always be the latest date as opposed to the earliest.
 |  | Test6 |  |  |  |  |  | 2021-06-25 16:12:59 |  |  |  | Test2 |  |  | < this should be 7/12/21 (cell I59)
 |  | Test1 |  |  |  |  |  | 2021-06-25 16:14:05 |  |  |  | Test3 |  |  | and so on
 |  | Test8 |  |  |  |  |  | 2021-06-25 16:14:46 |  |  |  | Test4 |  |  | …
 |  | Test10 |  |  |  |  |  | 2021-06-25 16:15:17 |  |  |  | Test5 |  |  | …
 |  | Test11 |  |  |  |  |  | 2021-06-25 16:15:49 |  |  |  | Test6 |  |  | …
 |  | Test12 |  |  |  |  |  | 2021-06-25 16:16:18 |  |  |  | [NAME] |  |  | …
 |  | Test13 |  |  |  |  |  | 2021-06-25 16:16:38 |  |  |  | Test8 |  |  | …
 |  | Test14 |  |  |  |  |  | 2021-06-25 16:18:15 |  |  |  | Test9 |  |  | …
 |  | Test15 |  |  |  |  |  | 2021-06-25 16:18:42 |  |  |  | Test10 |  |  | …
 |  | Test16 |  |  |  |  |  | 2021-06-28 09:27:18 |  |  |  | Test11 |  |  | …
 |  | Test17 |  |  |  |  |  | 2021-06-28 09:27:49 |  |  |  | Test12 |  |  | …
 |  | Test18 |  |  |  |  |  | 2021-06-28 09:28:13 |  |  |  | Test13 |  |  | …
 |  | Test1 |  |  |  |  |  | 2021-06-28 09:30:48 |  |  |  | Test14 |  |  | …
 |  | Test2 |  |  |  |  |  | 2021-06-28 09:34:46 |  |  |  | Test15 |  |  | …
 |  | Test3 |  |  |  |  |  | 2021-06-28 09:35:52 |  |  |  | Test16 |  |  | …
 |  | Test4 |  |  |  |  |  | 2021-06-28 16:23:31 |  |  |  | Test17 |  |  | …
 |  | Test5 |  |  |  |  |  | 2021-06-29 15:57:41 |  |  |  | Test18 |  |  | …
 |  | Test6 |  |  |  |  |  | 2021-06-30 15:43:40 |  |  |  | Test19 |  |  | …
 |  | [NAME] |  |  |  |  |  | 2021-06-30 15:44:36 |  |  |  | Test20 |  |  | …
 |  | Test8 |  |  |  |  |  | 2021-06-30 15:45:21 |  |  |  | Test21 |  |  | …
 |  | Test9 |  |  |  |  |  | 2021-07-01 15:36:49 |  |  |  | Test22 |  |  | another example:
 |  | Test10 |  |  |  |  |  | 2021-07-01 15:38:49 |  |  |  | Test23 |  |  | < this should be 7/14/21 (cell I95)
 |  | Test11 |  |  |  |  |  | 2021-07-01 15:40:58 |  |  |  | Test24 |  |  | and so on
 |  | Test12 |  |  |  |  |  | 2021-07-01 15:41:38 |  |  |  | [NAME] |  |  | …
 |  | Test13 |  |  |  |  |  | 2021-07-06 11:28:06 |  |  |  | Test26 |  |  | …
 |  | Test14 |  |  |  |  |  | 2021-07-06 11:28:50 |  |  |  | Test27 |  |  | …
 |  | Test15 |  |  |  |  |  | 2021-07-06 11:29:20 |  |  |  | Test28 |  |  | …
 |  | Test16 |  |  |  |  |  | 2021-07-06 11:29:55 |  |  |  | Test29 |  |  | …
 |  | Test17 |  |  |  |  |  | 2021-07-06 11:31:10 |  |  |  | Test30 |  |  | …
 |  | Test14 |  |  |  |  |  | 2021-07-06 11:33:28
 |  | Test15 |  |  |  |  |  | 2021-07-06 11:34:07
 |  | Test16 |  |  |  |  |  | 2021-07-06 11:34:52
 |  | Test17 |  |  |  |  |  | 2021-07-06 11:35:36
 |  | Test18 |  |  |  |  |  | 2021-07-06 11:40:24
 |  | Test19 |  |  |  |  |  | 2021-07-06 11:45:18
 |  | Test20 |  |  |  |  |  | 2021-07-07 09:31:15
 |  | Test21 |  |  |  |  |  | 2021-07-07 15:18:58
 |  | Test22 |  |  |  |  |  | 2021-07-07 15:20:32
 |  | Test23 |  |  |  |  |  | 2021-07-07 15:23:09
 |  | Test24 |  |  |  |  |  | 2021-07-09 10:10:35
 |  | [NAME] |  |  |  |  |  | 2021-07-09 10:11:19
 |  | Test26 |  |  |  |  |  | 2021-07-09 10:18:04
 |  | Test27 |  |  |  |  |  | 2021-07-09 10:32:52
 |  | Test28 |  |  |  |  |  | 2021-07-09 15:51:57
 |  | Test29 |  |  |  |  |  | 2021-07-09 15:58:19
 |  | Test30 |  |  |  |  |  | 2021-07-09 15:59:18
 |  | Test10 |  |  |  |  |  | 2021-07-09 16:00:04
 |  | Test11 |  |  |  |  |  | 2021-07-09 16:03:21
 |  | Test12 |  |  |  |  |  | 2021-07-09 16:03:40
 |  | Test13 |  |  |  |  |  | 2021-07-09 16:05:42
 |  | Test14 |  |  |  |  |  | 2021-07-09 16:07:15
 |  | Test15 |  |  |  |  |  | 2021-07-09 16:07:38
 |  | Test16 |  |  |  |  |  | 2021-07-12 09:39:01
 |  | Test17 |  |  |  |  |  | 2021-07-12 09:39:43
 |  | Test18 |  |  |  |  |  | 2021-07-12 09:40:32
 |  | Test1 |  |  |  |  |  | 2021-07-12 09:41:20
 |  | Test2 |  |  |  |  |  | 2021-07-12 09:42:57
 |  | Test3 |  |  |  |  |  | 2021-07-12 09:43:25
 |  | Test4 |  |  |  |  |  | 2021-07-12 09:43:55
 |  | Test5 |  |  |  |  |  | 2021-07-12 09:47:59
 |  | Test6 |  |  |  |  |  | 2021-07-12 09:48:51
 |  | [NAME] |  |  |  |  |  | 2021-07-12 09:51:06
 |  | Test8 |  |  |  |  |  | 2021-07-12 09:54:30
 |  | Test9 |  |  |  |  |  | 2021-07-12 10:05:35
 |  | Test10 |  |  |  |  |  | 2021-07-12 09:56:39
 |  | Test11 |  |  |  |  |  | 2021-07-12 09:57:15
 |  | Test12 |  |  |  |  |  | 2021-07-12 09:57:37
 |  | Test13 |  |  |  |  |  | 2021-07-12 09:59:12
 |  | Test14 |  |  |  |  |  | 2021-07-12 10:00:10
 |  | Test15 |  |  |  |  |  | 2021-07-12 10:00:35
 |  | Test16 |  |  |  |  |  | 2021-07-12 10:02:49
 |  | Test17
 |  | Test14 |  |  |  |  |  | 2021-07-12 10:05:35
 |  | Test15 |  |  |  |  |  | 2021-07-12 09:56:39
 |  | Test16 |  |  |  |  |  | 2021-07-12 09:57:15
 |  | Test17 |  |  |  |  |  | 2021-07-12 09:57:37
 |  | Test18 |  |  |  |  |  | 2021-07-12 09:59:12
 |  | Test19 |  |  |  |  |  | 2021-07-12 10:00:10
 |  | Test20 |  |  |  |  |  | 2021-07-12 10:00:35
 |  | Test21 |  |  |  |  |  | 2021-07-12 10:02:49
 |  | Test22 |  |  |  |  |  | 2021-07-13 15:58:24
 |  | Test23 |  |  |  |  |  | 2021-07-13 16:04:18
 |  | Test17 |  |  |  |  |  | 2021-07-13 16:02:22
 |  | Test14 |  |  |  |  |  | 2021-07-12 10:05:35
 |  | Test15 |  |  |  |  |  | 2021-07-12 09:56:39
 |  | Test16 |  |  |  |  |  | 2021-07-12 09:57:15
 |  | Test17 |  |  |  |  |  | 2021-07-12 09:57:37
 |  | Test18 |  |  |  |  |  | 2021-07-12 09:59:12
 |  | Test19 |  |  |  |  |  | 2021-07-12 10:00:10
 |  | Test20 |  |  |  |  |  | 2021-07-12 10:00:35
 |  | Test21 |  |  |  |  |  | 2021-07-12 10:02:49
 |  | Test22 |  |  |  |  |  | 2021-07-14 16:06:23
 |  | Test23 |  |  |  |  |  | 2021-07-14 16:08:07
 |  | Test17 |  |  |  |  |  | 2021-07-14 16:10:06
 |  | Test14 |  |  |  |  |  | 2021-07-14 16:11:52
 |  | Test15 |  |  |  |  |  | 2021-07-14 16:12:32
 |  | Test16 |  |  |  |  |  | 2021-07-14 16:12:54
 |  | Test17 |  |  |  |  |  | 2021-07-12 10:05:35
 |  | Test18 |  |  |  |  |  | 2021-07-12 09:56:39
 |  | Test19 |  |  |  |  |  | 2021-07-12 09:57:15