1. K

    Excel [DataSource.Error] Microsoft SQL:

    Hello Everyone, I am running into an error when uploading SQL in Excel from database. The message is below. How do I get around this issue with constraint or index? I have done a lot of research but I am stuck. I am not sure what I am missing at this point and I am seeking your help. Error...
  2. L

    Finding Max Value Combination with Two Constraints

    Hello, I am trying to generate all combinations of sums taking 5 values from one set of numbers, and 1 value from another set of numbers, with an additional constraint. I am trying to determine the combinations of 5 "Drivers and 1 "Team" that will generate the highest sum of 'Value' with the...
  3. N

    How to find all combinations within a constraint

    I am after some code/advice for Access. I have a list of Order Numbers(Unique) and what cubic metres that each are, I also have a cost benefit per Order. I would like to run some code to be able to find every combination of Orders but within a given constraint of Cubic size (65Cube) to find the...
  4. O

    [Solver] Problem with constraints

    Hi, I'm trying to do a workbook to find a maximum probability with some one constraint. It doesnt find any feasible solution but I do not find any problem with my workbook. Does anyone have a clue of how it could work? I am trying to find max value of cell D15 with help of editing cell H2:J14...
  5. H

    Solver - Best method/options possible to get desired result

    Hi, I am trying to set up solver to determine the best possible tax distribution of income (variables) across multiple entities, based on their initial existing income, in order to minimize their gross tax payable (objective). My main constraint is a cell which must equal zero. When the...
  6. C

    cartesian product with Max constraint / VBA code / Power query Trick

    Hi Excel Masters, I am trying to list all the combinations of a qty X breakdown within a 2 dimensions tables. In other words, lets imagine I have 1 unit of a product in stock, what are the combinations of destinations that I could send that product to (Clients x in Region Y) Example 1...
  7. I

    Constraint Modeling for Solver

    I think my logic is a little off... I have three products (Small, Medium, Large)-produced across 3 plants/locations: Product S=Small M=Medium L= Large Plant 1=1 Plant 2=2 Plant 3=3 Constraint: Production of Small cannot be greater than 5x the production of Medium 5(Xs1+Xs2+Xs3)<=...
  8. R

    College Excel Upcoming Grad and Need Help! Please!

    Hey all, I just created my account today becuase I could see the level of intelligence that is being shared across this forum. I recently got an internship at a industrial company and I'm having a pain in the *** trying to get this model I am building for them to work. May seem simple for some...
  9. N

    Lookup Maximum Value Subject to Constraints

    Ok, this has been killing me for a few days. I have two tables Number 1: PK Date A 1/1/2006 B 2/1/2009 C 3/1/2007 D 5/1/2007 Number 2: PK Date A 1/1/2005 A 2/1/2006 A 5/1/2009 B 2/1/2009 B 5/1/2010 C 5/1/2007 D 4/1/2007 So I want a...
  10. L

    Help with constraints in solver

    Hello again, this time I have a question regarding excel's "solver" add-in. Basically I want to hit a certain number which is the sum of some numbers times some other numbers. Here's the example: <X> A) 1 * (BLANK) B) 14 * (BLANK) C) 77 * (BLANK) I'm using solver to fill in the...

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
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 "".
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