peak picking help

Welcome to the forum.

How noisy is the data? Post it.

You could use a formula in column C with which to filter the peak values
Filter on Not Equal #N/A

C2: =IF(AND(B2>B3,B2>B1),B2,IF(AND(B2<B3,B2<B1),B2,NA()))

In D2:D7 you can use this array formula, use CTRL+SHIFT+ENTER to commit formula.

=LARGE(IF(ISNA(C2:C1000),0,C2:C1000),ROW()-1)

In E2:E7 use

=INDEX($A$2:$A$1000,MATCH(D2,$C$2:$C$1000,0))

After reading this thread, and in advance, thank you for everyone's assistance...
I noticed Shg asked how noisy the data was: So, are there any excel tools that could facilitate peak picking in far noisier data? (Excel 2008 - OS X: Snow Leopard)
I ran an experiment to collect the oscilloscope data of a heart contracting as it was retrieved by an isotonic transducer. A baseline run of the data is attached. You'll see that It has peaks and troughs like any other wave, but since it's physiological data, it's not very clean.
There's also peaks roughly halfway between the larger peaks which correspond to the atrial systole (the highest peaks are the ventricle systole). In other words, there are peaks for both the Lub and the Dub in the Lub-Dub of the heartbeat (fyi, this is Rana catesbeiana ~ animal physiology lab). I need to locate both.
Cheers

edit: the two red highlighted rows represent an atrial peak and a ventricle peak, demonstrating just how undistinguished the atrial peak indeed is.

Hi theoneness,

could you please take a moment to read the forum rules and then start your own thread? Feel welcome to link to this one if it helps provide background to your question.

cheers

herbds7, please use the forum tools to upload files, rather than untrusted external sites.