Forum Discussion
Special Support in time calculations for similar criteria
Hi All, I'm searching for a solution for a complicated problem I'm facing a month ago. As shown in attached picture, this file is to monitor and record repetitive failures in our plant. In this file...
Subtract from the current failure date the maximum back to service time of the set of rows with the same part number and for which the back to service time is before the current failure date.
=IFERROR($G2-
MAX(
FILTER($J$2:$J$9,($D$2:$D$9=$D2)*($J$2:$J$9<$G2))
)
,0)