Hi all,
I have a series that comprises of two rows:
Row 1 is date
Row 2 are values
I am trying to find a formula where I can identify where in row two the value chages from positive to negative, and where it changes from positive to negative it should return the date the value changes from positive to negative ie:
ROW 1 08-Jan 09-Jan 10-Jan
ROW 2 1111 22222 -33333
The formula should identify that in row 2 the negative value occurs at -33333 and at the 10th of January.
Is this possible to accomplish by a formula?
Cheers
Robert