Forum Discussion
RobTech1
Oct 03, 2019Copper Contributor
Using index match offset to find first date that amounts drop to zero
Hi, Trying to build a formula that returns the first date that a series of amounts ceases, ie drops to zero, using an index on date range, and attempting to match where amount is zero and amount of ...
- Oct 04, 2019
In the attached file, the formula in H2 is:
=INDEX(B1:F1,
MATCH(LOOKUP(2,1/(B2:F2>0),B1:F1),
B1:F1,0)+1)
Twifoo
Oct 04, 2019Silver Contributor
In the attached file, the formula in H2 is:
=INDEX(B1:F1,
MATCH(LOOKUP(2,1/(B2:F2>0),B1:F1),
B1:F1,0)+1)