I have a set of data about 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=0B224nfA5sDRCd3huRzlEelB4cXM 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. Alessandro
برچسب:
نویسنده: استخدام کار