Elapsed time of the failure event.
I must report the elapsed time of each one of the different registered failures.
I've done so far with the help of the subtotals command. And manipulating the subtotal function that the result of the command delivers for each subgroup (from SUBTOTAL (9, B2: B7) to SUBTOTAL (4, B2: B7) -SUBTOTAL (5, B2: B7)). For this I relice a macro that locates the subtotal function and replaces it with the one shown.
In the attached file our details!
It is my interest to give solution using the excel functions.
MAXIFS (), COUNTIFS (), SUMPRODUCT (), LOOKUP (), INDEX (,, MATCH ()), etc., etc. These are the functions used in many of the examples seen. But I can not extrapolate them to my particular case.
I must report the elapsed time of each one of the different registered failures.
I've done so far with the help of the subtotals command. And manipulating the subtotal function that the result of the command delivers for each subgroup (from SUBTOTAL (9, B2: B7) to SUBTOTAL (4, B2: B7) -SUBTOTAL (5, B2: B7)). For this I relice a macro that locates the subtotal function and replaces it with the one shown.
In the attached file our details!
It is my interest to give solution using the excel functions.
MAXIFS (), COUNTIFS (), SUMPRODUCT (), LOOKUP (), INDEX (,, MATCH ()), etc., etc. These are the functions used in many of the examples seen. But I can not extrapolate them to my particular case.