Trend using the same formula as the fill handle does

R

Roy G. Biv

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top