Multiple values from the same list of numbers

D

davis-wsu

I have a (long) list of spectral data. It consists of 1 column of time
increments, and 1 column of intensity values. I am trying to find the maximum
for each of three peaks in the data, plus, once the maximum has been found,
the values closest to halfway between the baseline and maximum intensity.
This will be 4 values; two on either side of the peak bracketing the halfway
point. I can use VLOOKUP or INDEX and MATCH to find these values on one side
of the maximum, but cannot figure out how to tell Excel to look on the other
side of maximum, especially for multiple peaks. Any help here would be
greatly appreciated.
 
D

davis-wsu

I can be reached at (e-mail address removed)
It is actually ion mobility spectrometry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top