Forum Discussion
problem with solver in excel
Riny_van_Eekelen thank you for your reply. I have 200+ columns and several rows, this is manual exercise . I want to see some different option like solver where I can change total pressing the button It will change all columns amount.
This is the last option I will use.
I think you need to upload your actual spreadsheet, or else a more accurate representation of it. You say you have "200+ columns and several rows," but the example you gave shows only one column with more than several rows. So @Riny_van_Eekelen gave you a reasonable answer to what was an ambiguous question.
For what it's worth, Solver is really powerful, but also well known to be very difficult to master, so it's not at all surprising that you might get an error message. I have a recent edition of the Excel Bible 2019, and the authors make a point of underscoring how complex that particular Add-In product is. It makes it doubly difficult then when your description of the situation is ambiguous. So if it's possible to upload your original workbook/spreadsheet and give a clearer description of what you're trying to do, that would help us help you.
mathetes Thank you for your reply. sorry for the late reply as it was weekend for us.
I am attaching here with sample data sheet in which column HB is total but I need total as per Column HC.
I have tried Solver but it is giving the error while changing the total.
Please have a look at the attached workbook. It took about 30 seconds to create the formulae needed across the 208 columns. I did the calculations in Sheet2. You can easily copy all of this down the rows you need to recalculate. Once you have done this, you can copy-paste-values in order to preserve the calculated values and delete Sheet1. No need for Solver.
- Thanks for reply. I know this solution but I am searching like goal seek or solver solution.
