Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching a value that appears multiple times
I have 2 columns with data in them, basically representing a gaussian distribution. Column A has the "X-axis" values and so is uniformly ascending with no duplicates. Column B has the "Y-axis" values and increases up to a maximum and then decreases again (this is data from an instrument and so its not completely smooth but is close). An example is below. 0 4 1 8 2 16 3 27 4 50 5 27 6 16 7 8 8 4 What I would like to do is get the 2 Column A values where the corresponding column B value is half of the max (in the case above, 25 is not available so the closest is 27). I am trying to calculate the difference between these values, so in the example, I would have 5-3. Is there a way to do this? Thanks. -- BKGT ------------------------------------------------------------------------ BKGT's Profile: http://www.excelforum.com/member.php...o&userid=33862 View this thread: http://www.excelforum.com/showthread...hreadid=536387 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting multiple minimum times | Excel Discussion (Misc queries) | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
Count # of times value "x" appear across multiple worksheets | Excel Worksheet Functions | |||
How do I count how many times a code appears in a column? | Excel Worksheet Functions |