Most valuable professional
  • Hot Topics

Excel 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: Inputs : Qty 1 in stock in B1 for for below table starting A3(Clients / Regions) Qty Region1 Region2 Region3 . Outputs: in Col L 1 and M1 Qty1 Qty1 Qty1 Qty1 Qty1 Qty1 Qty1 Qty1

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of April 29, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel