Forum Discussion
problem with solver in excel
If you mean that you want to restate the values for A to J so that the sum becomes 400, but keeping the same ratio as originally, the formulae in the attached workbook (column C) may offer you a solution.
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.
