Home Excel VBA Code - Combinations with restrictions
Reply: 0

Excel VBA Code - Combinations with restrictions

user1208 Published in March 18, 2018, 5:11 pm

I have to produce a list of combinations which are indicators to fields as I am trying to produce some conditions to interrogate data.I have some code for the combinations from here.

In the example of Power/Torque/Cylinders with a combination of 1,2,4:

I need to work out the combinations of those 3 fields, so the output would be:

So essentially all combinations but not from the same 'bucket' if that makes sense?

Edit: The number of combinations (ie 3 in the example) will change as per the link I provided. The combinations from the link determine which field to look at or use. Eg combination 123 would be the first 3 fields in the image. Combination 1,2 would be tge first 2 and 1,3 would be first and last. I have the code for that.

Now we have the combination buckets, need to work through the combinations across thise fields.

Also I am looking for guidance on how to approach the algo and not necessarily someone to do it for me 😊

As another example, if 1,2,3 were the column combination, the expected output would be:





You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.310483 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO