Hi everyone,
I am trying to interpolate between multiple values across the X, and Y axis.
SO far it interpolates the rows perfectly but the columns it seems to repeat numerics.
I am using the Trend / Offset / Match criteria that Hui kindly provided.
I have indicated the error in red with...
Please help - I am trying to interpolate table values for multiple numbers - I have tried forecast and trend and neither seem to supply the correct values:
EG: If I had to interpolate between the given data - I would work out the difference between(92.4-91.2)=1.2, and (45-40)=5 then divide...