Thread: Interpolation based on Average

Hello

First time post so please bare with me.

I have two numbers as follows:

Dec-11 1,071.69

And I have an Average for Dec-12 1,087.46.

I need to interpolate in Excel the numbers such that for each month of 2012 there is linear interpolation from 1071.69 to a max of 1,087.46. HOWEVER, the average of the interpolated numbers must equal 1,087.46.

Any ideas?
Thanks
Ed