Join Date
Aug 2016
Posts
1


Default How to find local maximas/minimas in-between points that crossed 0 on the x-axis?
Apologies if the post title was unclear, here's what I meant.

- I have plotted a line graph with only 1 line.
- This line ranges between -2% and 1.5%, it looks like a stock graph with ups and downs.
- My objective here is to find the maximum or minimum in-between two points that have crossed 0 on the x-axis. The two points that have crossed the x-axis must have a maximum or minimum inside that is ABOVE 1% or BELOW -1%.

Further explanation... This line I plotted here has data that goes up and down in-between -2% and 1.5%. Sometimes the line will fluctuate very slightly between -1% and 1%. I'm trying to find all the peaks (maximums) and abysses (minimums) that are over 1% or under -1%, with the crucial condition that the two points surrounding the peaks or abysses must have crossed 0 on the x-axis.

If you want clarification, please do not hesitate! Big thanks.

Attach your spreadsheet. That will help.