Dear all,
I have a big data set of which a portion can be found in attached example. In general you can see reoccurring cycles of which I would like to count how many times a cycle has a max in the given time period.
What I tried so far is counting peaks, I've currently used the following formula in column C; =IF(IF(AND(B4>B5;B4>B3);B4;NA())>1500;IF(AND(B4>B5;B4>B3);B4;NA());NA()) ; which picks up all peaks above 1500. How ever some peaks are duplicates (yellow circles). Is there a formula which only generates one peak per cycle in stead of multiple peaks due to noise in the data?
In the end I would like to obtain the total amount of peaks (which is in the example 21), maybe above is not the smartest way to get this number because you still need to make a table and filter out the #NA(). Please let me know if there are any other suggestions to get the amount of peaks.
Hope somebody can help out!
Bookmarks