Sorry if the title is unclear, I didn't want to be too specific.
So my problem is:
I have (a lot of) raw data that translates into graphs with a single peak (climbing from 0 to max value) and thereafter dipping into a minimum and climbing back up again.
Simplified such data would look like this:
x y
0 0
1 3
2 8
3 15
4 8
5 6
6 5
7 6
8 7
9 8
I want to have a cell to return the minimal "y" value (5) from the range AFTER the maximal "y" value (15) (the plateau minimum).
So I need a function to look up the maximal "y" value, defining a range from that cell to the end of the data and giving me the minimum from that set range.
Bookmarks