# 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.

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.
I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.

Last edited by a moderator:

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.

### Which adblocker are you using?

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

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