Finding the earliest date/time when all test parameters meet their target simultaneously

[Alex_a]

Good Morning Experts,

I need a VB code to the following: (I am attaching the spreadsheet what I am looking for in the main tab)

I have a columns listing customer numbers and 9 tests to verify their products. Each test has a date/time, result and a target acceptance target. I need to find the earliest day/time when all parameters simultaneously meet their respective target. Thank you so much!

Test 1-- Customer 1, 2/20/2020 11:20 am, 7.0 (test result) target is 8 or below
Test 2--- Customer 1, 2/20/2020 11:15 am, 51 (test result) target is 50 or below
Test 2--- Customer 1, 2/20/2020 11:21 am, 50 (test result)
Test 3-- Customer 1, 2/20/2020 11:06 am, 140 (test result) target is 130 or less
Test 3-- -Customer 1, 2/20/2020 11:22 am, 120 (test result)
Test 4---Customer 1, 2/20/2020 11:21 am, 61 (test result) target is 60 or above
test 5--- Customer 1, 2/20/2020 11:18 am, 33 (test result) target is equal or less than 35
Test 6----Customer 1, 2/20/2020 11:16 am, -1 (test result) target is 0 up to +2 (less than zero is not acceptable, above 2 is not acceptable either)
Test 6----Customer 1, 2/20/2020 11: 23 am, +1 (test result)
Test 7--- Customer 1, 2/20/2020 11:21 am, yes (test result) target is yes
Test 8-- Customer 1, 2/20/2020 11: 15 am, 7.1 (test result) target is 7.0
Test 9--- Customer 1, 2/20/2020 11:18 am, 7.33 (test result) target is 7.32 or above
Solving this one manually, the earliest time all 9 parameters passes their targets is 2/20/2020 11:23 am

 

[AlanSidman]

crossposted: https://www.ozgrid.com/forum/index....all-tests-parameters-meet-their-respective-t/

 

[vletm]

Alex_a
Have You read: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ ?

 

[Fluff13]

Also posted

Finding the earliest date/time when all test parameters meet their target simultaneously

Good Morning Experts, I need an array formula or a VB code to the following: (I am attaching the spreadsheet what I am looking for in the main tab) I have a columns listing customer numbers and 9 tests to verify their products. Each test has a date/time, result and a target acceptance...

www.excelforum.com

and

Finding the earliest date/time for multiple test targets

Good Morning Experts, I need an array formula or a VB code to the following: (I am attaching the spreadsheet what I am looking for in the main tab) I have a columns listing customer numbers and 9 tests to verify their products. Each test has a date/time, result and a target acceptance target...

www.mrexcel.com