Linear interpolation of hourly data into 15 minute data

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it is broken on this forum.

Hope this helps.

Pete

Thanks,
i want to attach the workbook but the paperclip icon was not working. U can see the sheet named Karnataka where i was continuing my work.

Try this in J2:

=IFERROR(INDEX(E:E,MATCH(I2,$B:$B,0)),INDEX(E:E,MATCH(I2,$B:$B,1))+MOD(ROWS($1:1)-1,4)*(INDEX(E:E,MATCH(I2,$B:$B,1)+1)-INDEX(E:E,MATCH(I2,$B:$B,1)))/4)

For the 15-min intervals it takes 1/4, 2/4 and 3/4 of the difference between the 6:30 and 7:30 data, giving you a linear interpolation between those values.

Hope this helps.

Pete

thanks a lot pete,
its working..

anup

Glad to hear that - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread and mark this thread as SOLVED.

Pete

Hey pete,
the above formula for bi-linear interpolation seems to work well till now but when i used it today it gives the answer in decreasing order as if the second "y" value is given as zero.see the sheet 2 and the concerned columns are "m","n","o".

thank you

I can't see any Sheet2, and there is no date column or even formula in your Sheet1, so I don't know how you have arrived at those numbers.

Pete