Interpolate with Excel | FORECAST function can interpolate | Excel Off The Grid

[@RomansChap8]

Dude! You don't know how much this helps me! I have been using excel for over a year with over 900+ cells that I have separated into over 150 data tables. I manually forecasted all of them. My data changes every year, so this is going to help me out SO MUCH!!!

[@ExcelOffTheGrid]

You're welcome. I'm glad you found it. 😁

[@RetiSports]

Excellent! I use the OFFSET function in addition to MATCH and FORECAST to do exactly this, but your method of using INDEX works better and is more straightforward. Thanks!

[@alekseyk7266]

Thank you! You explained complex for me theory in a simple way!

[@ExcelOffTheGrid]

Glad it was helpful!

[@МикаэльОвакимян-в1ч]

Thank you very much!

[@NFrmrsNFD]

Brilliant method and exactly what I needed!

[@ExcelOffTheGrid]

Great news - I'm glad it helped.

[@ditnom6482]

It deserves a million views ! 😊

[@ExcelOffTheGrid]

Thanks - I would love 1 million views. 😁

[@purohitamadithyaudaykiran4320]

So clear and neat . Exactly what i was looking for. Thanks a ton

[@ExcelOffTheGrid]

You are welcome!

[@SHDEdits]

Definitely saving this one

[@ExcelOffTheGrid]

Great news. 👍

[@Arbitrator207]

Would love to see how Xlookup simplifies the formula.

[@LenaPfeiffer-t4p]

Thank you, this was incredibly helpful!!

[@ExcelOffTheGrid]

You're welcome 😁

[@wayneedmondson1065]

Hi Mark. Nice one! This is not a process that I normally need to do in my work. Nevertheless, interesting. Very well explained and easy to follow. If it ever comes up, now I know how to handle it. Thanks for sharing :)) Thumbs up!!

[@ExcelOffTheGrid]

Thanks Wayne. Even if you never need to interpolate, the use of FORECAST may be good for other areas. So it’s good to know what is possible :-)

[@MrMocomic221]

amazing! very detailed explanation

[@ExcelOffTheGrid]

Thank You 😁

[@stuh.5623]

Hi Mark thanks for the video. Interpolation is something I need to use in most of my spreadsheets (both 1D and 2D) and I have been using VBA functions for years now to get around it. I had been hoping the Microsoft would have included a function for this by now, especially with all the new functions they have released for Office365, but alas no. Your video gave me an idea for a better way of solving this than having to use VBA, as I have never used the FORECAST function before. I have made a little tweak to your solution and instead of using the INDEX function I'm using the OFFSET function which allows you to build arrays: =FORECAST(E2,OFFSET(A1,MATCH(E2,A2:A11,1),1,2),OFFSET(A1,MATCH(E2,A2:A11,1),0,2))

[@ExcelOffTheGrid]

OFFSET is equivalent to the INDEX method I showed. The only issue with OFFSET Is that depending on where it is in the calculation chain, it can cause slow calculation times. But if it’s running fast enough for you then go with it 💥💥💥

[@namHin22815]

Super helpful. Thanks a lot

[@ExcelOffTheGrid]

You're welcome!

[@tabishkhan9559]

Very well explained. God bless u.

[@ExcelOffTheGrid]

Thank you 😊

[@tabishkhan9559]

@@ExcelOffTheGrid it would be better if u make different series for beginners and advance level. May be even include statistics and data visualization using excel.

[@onurakkus1325]

very well explained , thank you

[@ExcelOffTheGrid]

You are welcome!

[@michaelfang1242]

Great tutorial, really appreciate it!

[@ExcelOffTheGrid]

Thanks Michael - I’m glad you found it useful.

[@krishnatate4765]

Very nice sir, very helpful ❤

[@ExcelOffTheGrid]

Thanks, I’m glad you like it.

[@krishnatate4765]

@@ExcelOffTheGrid sir I like ur all videos and chennal...

[@cesara7478]

Great video!

[@ExcelOffTheGrid]

😀

[@TheAlcor]

AWESOME! Thanks!

[@ExcelOffTheGrid]

You’re welcome.

[@dark86lightning30]

Thank you so much

[@anush19ck]

Hi sir nice video but can you please make a video where we have known y value & to find x value.

[@ExcelOffTheGrid]

To achieve that could you just switch the x and y around in the function?

[@sanyamishra2825]

@@ExcelOffTheGrid I have the same question; switching my x and y values would be an issue for me…

[@ExcelOffTheGrid]

@@sanyamishra2825why is that an issue? You are not switching the X and Y on the chart, just in the purposes of the function.

[@apocalypticbean]

thank you

[@chtsm2000]

Dear, Thank you for your video, can we make projection from Y axe value to determine the unknown equivalent value on x axe (projection on any curve)

[@ExcelOffTheGrid]

I’m the calculation the X and Y are interchangeable. Then, in the chart, just map then axes to the relevant values.

[@eshitab9667]

Hi! Thanks for the video. How can I find value of x's using known y's?

[@ExcelOffTheGrid]

Just flip the x and y arguments in the function.

[@ksoday4]

How did you get the new data to populate on the graph?

[@abdelrahman458]

nice job , thanks a lot

[@ExcelOffTheGrid]

You’re welcome 😀

[@Mayer2050]

Very nice - last Methode help me

[@ExcelOffTheGrid]

Perfect, great news.

[@kehindeadeyeye7190]

Hi Mark, thanks for the explanation. I used the last long function but I keep getting an error, 'you haven't entered enough argument for this function'. I don't know how to proceed. Can you help?

[@ExcelOffTheGrid]

Unfortunately it means you’ve probably missed a comma, or a bracket somewhere a long the line. If you follow the link in the descriptions box. You can get to the blog post. You can copy and paste the formula from there. Then adapt it to your specific cells... that might work. 😀

[@edwinroger1718]

A tip: watch series at Flixzone. Been using them for watching all kinds of movies recently.

[@noahjared1596]

@Edwin Roger definitely, been watching on flixzone for since december myself =)

[@AAKASHSINGH-uq8cf]

Hey,what if we have a set of positive and negative numbers

[@ExcelOffTheGrid]

I wouldn’t expect it to make any difference.

[@sridharkrishnappanavanerth3388]

Sir, can you make a complete video on GETPIVOTDATA function. thanks

[@ExcelOffTheGrid]

I’ve got a blog post that might be useful. But it’s not entirely about GETPIVOTDATA: exceloffthegrid.com/getpivotdata-vs-cube-functions/

[@logi0825]

You don't explain 17.5. The video cuts off half the table, can't see it.

[@vinum3140]

Hi I need some help

[@HyperSquid1234]

BUT WHAT IF THE VALUE YOU WANT TO INTERPOALTE IS A Y-VALUE?!?! And you want to find the x-value

[@ExcelOffTheGrid]

From a formula perspective you can switch the X and Y values to interpolate one over the other. But when you chart the values, just remember to switch them back again.

[@fdshdsfdsqq]

❤^💯

[@ExcelOffTheGrid]

Wow!!! That is a lot of ❤️s.

[@mohammadosman6106]

Excellent. Great resource. Thanks a bunch.

[@ExcelOffTheGrid]

Glad it was helpful!

[@vivekroyzada]

Thanks a lot !

[@ExcelOffTheGrid]

You’re welcome.