Hi all,
I am trying to use the Solver add in. I want to solve for the orange highlighted cells in Sheet 2. I only have 3 categories here but in my full list I will be using over 60 and will be changing my target percentage. Right now I would like to change the product count to where the target = 90%. I have had to manually change them and keep testing them until i get to 80%.
Can someone please provide me with clear steps to use the solver.
Thank you so much!
Click Data > What-If Analysis > Goal Seek
Set Cell: D7
To value: 90%
By changing cell: C7
You could run a macro to automate this for each row:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Did this URGENTLY answer your question?!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks