ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Trend using the same formula as the fill handle does (https://www.excelbanter.com/excel-worksheet-functions/51104-trend-using-same-formula-fill-handle-does.html)

Roy G. Biv

Trend using the same formula as the fill handle does
 
Say you have a series of data points in a row. If you highlight the cells
containing that data series, then grab the fill handle and drag it over empty
cells to the right, Excel will trend the series forward. But suppose I want
to create a formula that does the exact same thing. For the sake of example,
say cells A2 through A10 have values in them already, and I want to create a
formula that would fill A11, A12, and A13 in the same way that dragging the
fill handle would.

Thanks!


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com