chemebak, I know my data are not linear and that's why I find it difficult solve the problem. I'll have a closer look and try to find the best solution suitable for the data set.
ec
Thanks chemebabak,
I'll test it tomorrow; I'm a bit tired now.
However, does this interpolation function generates values at specific even steps?
My data look like this:
depth column A (in m)
2
2.58
3.16
3.74
4.32
4.9
5.48
6.06
6.64
7.22
7.8
8.38
8.96
9.54
10.12
and variable beam attenuation...
I would appreciate if ivymike could post the macro that does the following:
1) Receive as input the complete list of data (x and y), and store it in an array
2) receive as input the X value for which a Y value is desired
3) loop through the list of data to find two input X locations that...
