Bob Umlas Interpolate Using Fill Series in Excel - 2398

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 27, 2021 .
Bob Umlas has a new book out. https://www.mrexcel.com/products/cool-excel-sh*t/ While I was working on indexing and layout of the book, I learned a lot of new Excel techniques, including this cool way to interpolate values.
If you enter a starting value in A1 and and ending values in A22, select A1:A22 and use Fill Series. Excel will automatically calculate the step value to create a perfect line.
maxresdefault.jpg


Transcript of the video:
Learn Excel from MrExcel Episode 2398.
A cool Bob Umlas trick to interpolate with Fhil Series.
Bob Umlas has a new Excel book out with 50 cool tricks. And as I was working on layout and indexing of that book, I kept learning all kinds of great new tricks, including this one, which I'm fairly sure I've never seen before and haven't had on the podcast before.
So we have to get from 281 to 224 in equal steps right?
And I guess I could count how many steps that is – 12. Divide that difference by 12 and so on.
No. Just choose the first cell to the last cell with all the blank cells in the middle.
Out here on the Home tab, far right-hand side Fill, Fill Series.
And in Fill Series, it automatically fills in the correct step value to get from that starting point to the ending point.
So let's say that we're at 50 and we need to get down here to 5674. How many do we need to add each day or each row?
Fill, Fill series and it calculates the exact amount to get you a nice straight line regression from the starting point to the ending point.
That's just one of the 50 tips in this book. Click the “I” in the top right hand corner.
It's out in ebook now. It will be out in print next year, but you can get the ebook now.
You'll learn all of those great cool tricks from Bob Umlas.
If you like these videos, please Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the YouTube comments below.
I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.
 
Last edited by a moderator:

Watch MrExcel Video

Forum statistics

Threads
1,127,044
Messages
5,622,381
Members
415,894
Latest member
silverhaze

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top