Spreadsheet: 869256d1715868245-meet-two-different-crieria-to-find-value-temp-4-aligw
Sheet: NewData

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