Finding the earliest date/time for multiple test targets

[alex_a]

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. 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

 

[Joe4]

Cross-posted here: Finding the earliest date/time when all test parameters meet their target simultaneously

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

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

 

[Fluff]

Now posted here as well

Finding the earliest date/time when all tests parameters meet their respective targets (pass) - OzGrid Free Excel/VBA Help Forum

GoodMorning Experts, I need an array formula for the following: (I am attaching the spreadsheet whatI 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…

www.ozgrid.com