goal seek variable cell

  1. C

    how to use goal seek for multiple columns that match search criteria

    I am trying to use a goal seek for every column that contains “2700” in row 38. If a column has “2700” in row 38, I’d like row 130 to equal 5 by adjusting row 50. Please note, in the row 38 contents it can be 2700 or a number of 2700 and letter combinations, which is why I have to do a search...
    • controlz
    • Thread
    • find find across row goal seek goal seek function goal seek variable cell
    • Replies: 1
    • Forum: Excel Questions
  2. J

    Goal Seek dynamic row referencing

    I have a several hundred row table running in Excel 2016 365Pro Plus. I’m trying to implement GoalSeek to determine a residual value on a row by row basis containing propertytransactions. I’ve been successfulrunning the following code on a single row (row 5): Sheets(“Residual_Analysis”).Select...
  3. G

    How to use a cell value as the "To value" value on Goal Seeking

    Hello, I have been looking for the solution for this problem for hours now, and I can't seem to find it, since the only results that show up when you include Excel goal seeking in your search are basic guides on how to use the Goal Seek feature. A detailed description of my problem: I am...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top