Spreadsheet: 869253d1715867517-meet-two-different-crieria-to-find-value-temp
Sheet: NewData

Reference | Short Date | Status
Test1 | 2024-01-04 00:00:00 | Failed
Test2 | 2024-01-04 00:00:00 | Successful
Test3 | 2024-01-04 00:00:00 | Failed
Test4 | 2024-01-04 00:00:00 | Successful
Test5 | 2024-01-04 00:00:00 | Successful
Test6 | 2024-01-04 00:00:00 | Successful
[NAME] | 2024-01-04 00:00:00 | Successful
Test8 | 2024-01-04 00:00:00 | Successful
Test1 | 2024-02-04 00:00:00 | Successful
Test2 | 2024-02-04 00:00:00 | Successful
Test3 | 2024-02-04 00:00:00 | Successful
Test4 | 2024-02-04 00:00:00 | Successful
Test5 | 2024-02-04 00:00:00 | Successful
Test6 | 2024-02-04 00:00:00 | Successful
[NAME] | 2024-02-04 00:00:00 | Successful
Test8 | 2024-02-04 00:00:00 | Successful
Test1 | 2024-03-04 00:00:00 | Successful
Test2 | 2024-03-04 00:00:00 | Failed
Test3 | 2024-03-04 00:00:00 | Successful
Test4 | 2024-03-04 00:00:00 | Successful
Test5 | 2024-03-04 00:00:00 | Successful
Test6 | 2024-03-04 00:00:00 | Successful
[NAME] | 2024-03-04 00:00:00 | Successful
Test8 | 2024-03-04 00:00:00 | Successful
Test1 | 2024-04-04 00:00:00 | Failed
Test2 | 2024-04-04 00:00:00 | Successful
Test3 | 2024-04-04 00:00:00 | Successful
Test4 | 2024-04-04 00:00:00 | Successful
Test5 | 2024-04-04 00:00:00 | Successful
Test6 | 2024-04-04 00:00:00 | Successful
[NAME] | 2024-04-04 00:00:00 | Successful
Test8 | 2024-04-04 00:00:00 | Successful
Test1 | 2024-05-04 00:00:00 | Failed
Test2 | 2024-05-04 00:00:00 | Successful
Test3 | 2024-05-04 00:00:00 | Successful
Test4 | 2024-05-04 00:00:00 | Successful
Test5 | 2024-05-04 00:00:00 | Successful
Test6 | 2024-05-04 00:00:00 | Successful
[NAME] | 2024-05-04 00:00:00 | Successful
Test8 | 2024-05-04 00:00:00 | Successful
Test1 | 2024-07-04 00:00:00 | Successful
Test2 | 2024-07-04 00:00:00 | Successful
Test3 | 2024-07-04 00:00:00 | Successful
Test4 | 2024-07-04 00:00:00 | Failed
Test5 | 2024-07-04 00:00:00 | Successful
Test6 | 2024-07-04 00:00:00 | Successful
[NAME] | 2024-07-04 00:00:00 | Successful
Test8 | 2024-07-04 00:00:00 | Successful
Test1 | 2024-08-04 00:00:00 | Successful
Test2 | 2024-08-04 00:00:00 | Successful
Test3 | 2024-08-04 00:00:00 | Successful
Test4 | 2024-08-04 00:00:00 | Successful
Test5 | 2024-08-04 00:00:00 | Successful
Test6 | 2024-08-04 00:00:00 | Successful
[NAME] | 2024-08-04 00:00:00 | Failed
Test8 | 2024-08-04 00:00:00 | Successful
Test1 | 2024-09-04 00:00:00 | Successful
Test2 | 2024-09-04 00:00:00 | Successful
Test3 | 2024-09-04 00:00:00 | Successful
Test4 | 2024-09-04 00:00:00 | Successful
Test5 | 2024-09-04 00:00:00 | Successful
Test6 | 2024-09-04 00:00:00 | Failed
[NAME] | 2024-09-04 00:00:00 | Successful
Test8 | 2024-09-04 00:00:00 | Successful
Test1 | 2024-10-04 00:00:00 | Failed
Test2 | 2024-10-04 00:00:00 | Successful
Test3 | 2024-10-04 00:00:00 | Successful
Test4 | 2024-10-04 00:00:00 | Successful
Test5 | 2024-10-04 00:00:00 | Successful
Test6 | 2024-10-04 00:00:00 | Successful
[NAME] | 2024-10-04 00:00:00 | Failed
Test8 | 2024-10-04 00:00:00 | Successful
Test1 | 2024-11-04 00:00:00 | Successful
Test2 | 2024-11-04 00:00:00 | Successful
Test3 | 2024-11-04 00:00:00 | Successful
Test4 | 2024-11-04 00:00:00 | Successful
Test5 | 2024-11-04 00:00:00 | Failed
Test6 | 2024-11-04 00:00:00 | Successful
[NAME] | 2024-11-04 00:00:00 | Successful
Test8 | 2024-11-04 00:00:00 | Successful
Test1 | 2024-12-04 00:00:00 | Successful
Test2 | 2024-12-04 00:00:00 | Successful
Test3 | 2024-12-04 00:00:00 | Successful
Test4 | 2024-12-04 00:00:00 | Successful
Test5 | 2024-12-04 00:00:00 | Successful
Test6 | 2024-12-04 00:00:00 | Successful
[NAME] | 2024-12-04 00:00:00 | Successful
Test8 | 2024-12-04 00:00:00 | Successful
Test1 | 15-04-2024 | Successful
Test2 | 15-04-2024 | Successful
Test3 | 15-04-2024 | Successful
Test4 | 15-04-2024 | Successful
Test5 | 15-04-2024 | Successful
Test6 | 15-04-2024 | Successful
[NAME] | 15-04-2024 | Successful
Test8 | 15-04-2024 | Successful
Test1 | 16-04-2024 | Successful
Test2 | 16-04-2024 | Successful
Test3 | 16-04-2024 | Successful
Test4 | 16-04-2024 | Successful
Test5 | 16-04-2024 | Successful
Test6 | 16-04-2024 | Failed
[NAME] | 16-04-2024 | Successful
Test8 | 16-04-2024 | Successful
Test1 | 17-04-2024 | Successful
Test2 | 17-04-2024 | Successful
Test3 | 17-04-2024 | Successful
Test4 | 17-04-2024 | Failed
Test5 | 17-04-2024 | Successful
Test6 | 17-04-2024 | Successful
[NAME] | 17-04-2024 | Successful
Test8 | 17-04-2024 | Successful
Test1 | 18-04-2024 | Successful
Test2 | 18-04-2024 | Successful
Test3 | 18-04-2024 | Successful
Test4 | 18-04-2024 | Successful
Test5 | 18-04-2024 | Successful
Test6 | 18-04-2024 | Successful
[NAME] | 18-04-2024 | Successful
Test8 | 18-04-2024 | Successful
Test1 | 19-04-2024 | Successful
Test2 | 19-04-2024 | Successful
Test3 | 19-04-2024 | Successful
Test4 | 19-04-2024 | Successful
Test5 | 19-04-2024 | Successful
Test6 | 19-04-2024 | Successful
[NAME] | 19-04-2024 | Successful
Test8 | 19-04-2024 | Successful
Test1 | 21-04-2024 | Failed
Test2 | 21-04-2024 | Successful
Test3 | 21-04-2024 | Successful
Test4 | 21-04-2024 | Successful
Test5 | 21-04-2024 | Successful
Test6 | 21-04-2024 | Failed
[NAME] | 21-04-2024 | Successful
Test8 | 21-04-2024 | Successful
Test1 | 22-04-2024 | Successful
Test2 | 22-04-2024 | Successful
Test3 | 22-04-2024 | Successful
Test4 | 22-04-2024 | Successful
Test5 | 22-04-2024 | Successful
Test6 | 22-04-2024 | Successful
[NAME] | 22-04-2024 | Successful
Test8 | 22-04-2024 | Successful
Test1 | 23-04-2024 | Failed
Test2 | 23-04-2024 | Successful
Test3 | 23-04-2024 | Failed
Test4 | 23-04-2024 | Failed
Test5 | 23-04-2024 | Failed
Test6 | 23-04-2024 | Failed
[NAME] | 23-04-2024 | Successful
Test8 | 23-04-2024 | Successful
Test1 | 24-04-2024 | Successful
Test2 | 24-04-2024 | Failed
Test3 | 24-04-2024 | Successful
Test4 | 24-04-2024 | Successful
Test5 | 24-04-2024 | Successful
Test6 | 24-04-2024 | Successful
[NAME] | 24-04-2024 | Failed
Test8 | 24-04-2024 | Successful
Test1 | 25-04-2024 | Successful
Test2 | 25-04-2024 | Successful
Test3 | 25-04-2024 | Successful
Test4 | 25-04-2024 | Successful
Test5 | 25-04-2024 | Successful
Test6 | 25-04-2024 | Successful
[NAME] | 25-04-2024 | Successful
Test8 | 25-04-2024 | Successful
Test1 | 26-04-2024 | Successful
Test2 | 26-04-2024 | Successful
Test3 | 26-04-2024 | Successful
Test4 | 26-04-2024 | Successful
Test5 | 26-04-2024 | Successful
Test6 | 26-04-2024 | Successful
[NAME] | 26-04-2024 | Successful
Test8 | 26-04-2024 | Successful
Test1 | 28-04-2024 | Successful
Test2 | 28-04-2024 | Successful
Test3 | 28-04-2024 | Successful
Test4 | 28-04-2024 | Successful
Test5 | 28-04-2024 | Successful
Test6 | 28-04-2024 | Successful
[NAME] | 28-04-2024 | Successful
Test8 | 28-04-2024 | Successful
Test1 | 29-04-2024 | Successful
Test2 | 29-04-2024 | Successful
Test3 | 29-04-2024 | Successful
Test4 | 29-04-2024 | Successful
Test5 | 29-04-2024 | Successful
Test6 | 29-04-2024 | Successful
[NAME] | 29-04-2024 | Successful
Test8 | 29-04-2024 | Failed
Test1 | 30-04-2024 | Successful
Test2 | 30-04-2024 | Failed
Test3 | 30-04-2024 | Successful
Test4 | 30-04-2024 | Successful
Test5 | 30-04-2024 | Successful
Test6 | 30-04-2024 | Successful
[NAME] | 30-04-2024 | Failed
Test8 | 30-04-2024 | Failed