AnsweredAssumed Answered

An equation in Excel to obtain the time when a variable changed for the last time

Question asked by canetman on Mar 22, 2016
Latest reply on Mar 29, 2016 by chegardt

I am looking for a single formula in Excel to obtain the last time when a variable changed from 1 to 0. Of course I can obtain the value of a variable in a determined time or a time range, but i am interested about finding the exact time when a variable achieved a determined condition (for example changing from 1 to 0). It is a very important to find it easily, with a single formula or equation (including the tag name and the condition). I want to avoid searching in the past with big tables and auxiliary formulas.

 

Thanks in advance!!!!

Outcomes