Calculate the required % Rate increase amount to obtain a goal

[tfarmer1]

This is something I can easily do with Goal Seek...however, I need to do that with a Table with 1,000 rows...plus each row has to be calculated independently, and then the Total Row will also have to be calculated. And of course there are many different ways the Table could be filtered, and the Total Row has to dynamically change regardless of how the Table is filtered.

If I could have a Formula that worked like Goal Seek, that would be optimal...and I don't want to write code to do it.. (Although I will if I can't figure this out...)

Here's the easiest way I can describe it...but it's one of the questions where if you ask "why" it will take a lot longer to explain. Just accept the scenario.

* Assume a checking account has a balance of $25,000 today
* Assume I will make a deposit monthly into the account.
* The account does not earn any interest; this is not a rate-of-return question.
* The first deposit is for $1,000.
* the 2nd Deposit is increased by 5%, or $1,050
* the 3rd Deposit is increased another 5%, or $1,103
* the 4rd Deposit is increased another 5%, or $1,158
etc
etc
etc
* the final deposit, the 12th one, is for $1,720.
* total amount of the 12 deposits was $15,917 and now my checking account balance is $40,917.


In that case, I provided the 5% growth rate, and calculated the ending bank balance. My case is where I want provide a "desired" bank balance, and Excel figures out the growth rate I need.
- For example, if I want my bank balance to be $42,000 at the end of 12 months, how much does each deposit need to increase?
- using Goal Seek, I can figure out the value is 6.131%.

There should be a simple file attached to this post, I hope...

How can I do that using my table of 1000 rows? Each row will have a different Initial Deposit value and a different Desired bank balance, and therefore a different Growth rate.