Special-K's formula should work, once you know which range to enter for the desired peak. Technically, I'm not sure that it is really different from a simple =MAX(A1:A8) since anything less than 3 cannot be the Max in a list of numbers that goes above and below 3. Of course, expanding this formula to include the entire data set will only find the max value of the largest peak, not the top of each peak.
I'm not familiar with the real algorithms that are used for this kind of signal processing. If this is something you need to be proficient in, I would suggest some research into signal processing algorithms. The simple algorithm I use for this sort of thing, on the rare occasion that I need it, takes its cue from basic calculus. The "max" of the peak (assuming no noise) will be the point where the slope of the signal crosses 0 (goes from positive to negative). I will add a column that calculates slope (usually a simple (B2-B1)/(A2-A1), though I can get more complicated depending on needs), then a second helper column to "tally" up or otherwise identify where the slope crosses 0. Then I can search these columns for the maxima and minima, test for max or min, and return the maxima.
Bookmarks