How do I identify multiple max peaks in data set

**jon2316** · 10-08-2008, 02:18 PM

I have a set of data about with approx 7500 cells all contained in one column. The data has a series of peaks that happen, and I need to identify each peak value and place it in a cell. The peak does not occur at regular intervals but they are somewhat regular, as in within 130-230 data points. So, if one could find the first peak in the first 200 cells, identify it and store it somewhere, then look in the next 200, store it, etc. I don't know how to do that in excel. Please help

Thanks
Jon

**ChemistB** · 10-08-2008, 02:30 PM

Not too sure without looking but this sounds like the simplest solution

Please Login or Register  to view this content.

Not sure if you need to pull over other cells or not.

**jon2316** · 10-08-2008, 03:12 PM

No, that won't work. The second series needs to start from where the last one left off. So if it found the first max value at row 150, it would then search from 151 to 350, then find it at say 233. Then it would search for max from 234-433... and so on.

Its not so easy

**darkyam** · 10-08-2008, 05:23 PM

Would these peaks be reccurring? Could you have a peak of say, 500, appear multiple times in the list? If not, then you could use something like =Max(B1:B200) for the top formula, then =Max(Offset(B1,Match(C1,$B$1:$B$7500,0),200,1)) and drag that down. If they can repeat, then I don't know of a way to do this.
It's a good thing this site is rife with people better than I am at Excel.

**jon2316** · 10-08-2008, 07:12 PM

I finally figured it out myself. Yes data does repeat. Its not that bad, used the offset function to define a new window to look in after I find each maximum.

Jon

**callme** · 10-08-2014, 01:27 AM

I'm dealing with the similar issues just that I have multiple columns but I don't seem to understand the solution stated. Jon mind helping me out?

**Max, Singapore** · 10-08-2014, 01:48 AM

Try plotting a simple line chart on your column data, and visually read-off the multiple peaks

**callme** · 10-08-2014, 05:42 AM

Identifying them is not hard, but then problem is I need to highlight them as peak(Change the font color). I couldchange them manually. however it's rather time consuming. Is there an alternate solution? a VBA code perhaps?

Anyone please help thanks!!