Replicating: Fill, Series..., Growth trend.

[JoshuaSQ]

Does anyone know how i might replicate the fill series of:
Fill, Series..., Growth trend.

The series results in a constant percentage increase but i don't know how to arrive at the percentage.

So- if i were to define two anchor points that are X steps apart how would i replicate the values obtained through the fill series.

I'm attaching a workbook which I hope clarifies what I am asking because I know im not explaining it well. Thank you in advance.

-Josh

[Bjornar]

Here is one solution.
I have broken each step of the prosess into separate formulas. I'm sure you can combine these into one megaformula if you like....

Don't know if my way of finding the row number of the anchors is the best way, and I'm sure someone else has another way, but it works.
This method requires the first anchor to be larger than $1 and the last anchor to be at least $1 larger than the first anchor.

Let me know if you have any questions

[JoshuaSQ]

Works great!

Thank you