Hi there,
I have a set of data with approximatively 25500 cells, all contained in one column.
The data has a series of peaks that occurs, and I need to identify the 2nd peak (and the 4th, the 6th, and so on where present).
I have than to consider the previous 200 data points of the 2nd peak (corresponding to the previous 20 seconds) in order to get a data range for a chart.
When the values are identified, I have to store it in another column and take it as reference for the chart.
At present I do it manually, looking on the chart and using the Ms Office tool “find and search”…
Here linked the example file: https://drive.google.com/open?id=0B2...3huRzlEelB4cXM
I hope that it will possible to find a function to do automatically but I don't know how to do that in excel.
Thanks for the attention and your help
Alessandro