Hello. I've stumbled upon this place several times and found some nice tricks to make my work a bit more efficient, so I figured I could ask this here.
Is there a way to make some general formula that will search for values, pick two that are on both sides of a certain value, then (mathematically) make a linear fit based on just those two values to find out at which point X the Y value is for example 1.5?
To clarify, I may have a big table of 100 different series with for example 60 measurement points. For each series, I want to determine at which X-point the Y-value reaches 1.5. The point will differ greatly for each series and the series don't follow the exact same rules of growth (it may also happen that the Y values start to diminish again after a certain point).
Example:
x series1 series2... series100
1 0.16 0.01 ..
2 0.24 0.20 ..
3 0.42 1.39
4 1.49 1.69
5 1.51 7.89
...
60 49.2 239
So for series1 the wanted value would be 4.5 and for series2 it would be around 3.37. Is there a way to do this efficiently and in a copy-paste manner for all series?
Bookmarks