I have been using goal seek successfully to back into a known number. This works great with a handful of lines - now I need it for 100s (probably 1000s) of lines. Any help would be greatly appreciated....
I want to know how I can programmatic use my linear interpolate equation without having the user or myself to use the Goal Seek function in the data menu, well I could use the function but I want it ...
I have to use the following formula: =POWER(b,(d+1))-N*(b-1)-1 I need to find b, so every time I run this I have to select the values for d and N, and then goal seek to make b the calculated ...