Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
interpolation
Dear Friends,
I am trying to obtain the interpolated value from column B and return the corresponding value from column A. There are two issues: I have repeated numbers in column B which in this case I want the lowest value from column A to be used and also as you can see the column A is between 0-1.8 and B is in percentage. For example 80% or 8% or 5% from column B corresponds to what values from Column A. Thanks for your help A B 0.046875 100.00% 0.09375 100.00% 0.421875 99.60% 1.03125 99.60% 1.078125 22.40% 1.125 18.40% 1.171875 15.60% 1.21875 13.60% 1.265625 12.40% 1.3125 11.20% 1.359375 10.00% 1.40625 9.20% 1.453125 8.80% 1.5 8.00% 1.546875 7.20% 1.59375 6.80% 1.640625 6.40% 1.6875 6.00% 1.734375 5.60% 1.78125 5.20% 1.828125 4.80% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Linear Interpolation | Excel Discussion (Misc queries) | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
I am looking for a function for linear interpolation | Excel Discussion (Misc queries) | |||
interpolation in a particular interval (HELP) | Excel Discussion (Misc queries) | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) |