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