cartesian product

  1. E

    Generating a list of combinations (similar to Cartesian Product but more than 1 from each list)

    Long time reader first time asker! I have a set of data and I am looking to generate a list of the combinations, I have found VBA and formulas but can't seem to get it right. It is similar to the Cartesian Product but rather than it being one from each list, there are multiples from each list...
  2. C

    VBA that provides unique combinations from data in multiple arrays (cartesian product)

    I need to add a fourth array, range and augment code under the srartrange.select section Sub cartesianproduct() Dim startrange As Range range1 =Application.InputBox(Prompt:="Please Select First Range", Type:=8) range2 =Application.InputBox(Prompt:="Please Select Second Range", Type:=8) Set...
  3. K

    Copy, sort, remove doubles, Cartesian product

    Hello, I have a tricky question for you. After running several macros (more than 10) I come up with data like the ones that you see on the attached file. The output data is not the same every time, meaning that I may have 10 records one day, and 100 records on another day. What I want is...
  4. 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...
  5. F

    Further help on Cartesian Product (shg)

    Hello everyone; If I could please ask for a little further help on the wonderful formula/macro of Mr shg found here https://app.box.com/s/47b28f19d794b25511be ; I was able to easily customize this table and add some more columns etc. and it works like a charm. Thank you shg! The next thing I'm...
  6. E

    Cartesian Product 8 sets

    Hi, I know it's normally for two sets only, but how about as many as 8 sets. is that possible or any other way to perform that? Thanks for all your help

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top