|
|
|
|
|
|
by whoknowswhat11
1664 days ago
|
|
|
Goal seek also covers various optimization / iteration scenarios. Or solver. Options exist for iterations and maximum change directly with circular references. https://bettersolutions.com/excel/formulas/circular-referenc... Adding in indirect/offset/lookups/indexes etc - I've gotten surprisingly far. I'm also OK doing VBA BUT the MAJOR downside of VBA - horrendous to share it and got worse over time for security reasons. Excel without VBA - you can give the "program" to anyone, and almost anyone can use it (and in a pinch change it). |
|
|