I thought that what I want to do would be rather simple, but after I spent a few hours on trying and searching the internet, I am finally here to ask you for ideas.
I have got a quantity that piecewise increases and decreases monotonically. So I would like to figure out my local extrema to some kind of determine the frequency and do some further evaluations at these points. I didn’t want to write a program for this because I thought it would be easier to do this using an application like Calc in the first place, but now I’m pretty surprised about how difficult that simple task seems to be.
I already tried to do something by appending a
+STYLE(AND(H299<CURRENT(), H301<CURRENT()), "Red, "Green") to my formulas and applying them to all cells of that column (so that H299 and H301 also shift). Do you have any other ideas?