Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values from the same list of numbers
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values from the same list of numbers
If seeing the data would be helpful, I am willing to use email correspondence.
"davis-wsu" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values from the same list of numbers
Xray spectrometry?
Let me know how to contact you. -- Biff Microsoft Excel MVP "davis-wsu" wrote in message ... If seeing the data would be helpful, I am willing to use email correspondence. "davis-wsu" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values from the same list of numbers
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple values in a list? | Excel Worksheet Functions | |||
create a list of single values from multiple values | Excel Worksheet Functions | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
look up one value that can list multiple corresponding values | Excel Discussion (Misc queries) |