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