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