Multiple values from the same list of numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davis-wsu - 12 Feb 2008 18:11 GMT

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.

Reply to this Message

davis-wsu - 12 Feb 2008 18:16 GMT

If seeing the data would be helpful, I am willing to use email correspondence.

> 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
[quoted text clipped - 5 lines]
> side of maximum, especially for multiple peaks. Any help here would be
> greatly appreciated.

Reply to this Message

T. Valko - 12 Feb 2008 19:01 GMT

Xray spectrometry?

Let me know how to contact you.

Signature

Biff
Microsoft Excel MVP

> If seeing the data would be helpful, I am willing to use email
> correspondence.
[quoted text clipped - 13 lines]
>> side of maximum, especially for multiple peaks. Any help here would be
>> greatly appreciated.

Reply to this Message

davis-wsu - 12 Feb 2008 19:13 GMT

I can be reached at clrntrules@yahoo.com
It is actually ion mobility spectrometry

> Xray spectrometry?
>
[quoted text clipped - 17 lines]
> >> side of maximum, especially for multiple peaks. Any help here would be
> >> greatly appreciated.

Reply to this Message