Hi All,
I've found plenty of articles about linear interpolation, but i'm having trouble getting the indexing part right. My data looks like this:
A, B, C
1-Jan-2000, 100
1-Feb-2000
1-Mar-2000
1-Apr-2000, 130
1-May-2000
1-Jun-2000
1-Jul-2000, 100
I'm after a formula that I can put in C that will return the value in B if it's a number, or otherwise, interpolate between the two nearest points above and below. So, the formula would return:
100
110
120
130
120
110
100
Any help much appreciated. Actual data set attached.
Bookmarks