Generate all possible combinations from 4 sets.

Using Excel 2010
Hello,

I am sure this is bit tricky question.

1st option I want to make all possible combinations from the 4 data sets, are in the column C, D, E and F…Result in the column I:L

2nd option I want to generate only those combinations they pass min & max sums as per value given in the cells I1 & I2.

Note: Why I want 2nd option in this example there are only 26880 sets…but (for example if data increase in 4 columns say for in C=55, D=70, E=35, F=30…so this will be 55*70*35*30 = 4042500 combinations…so far restring min and max would be handy.

I have tried to as much as possible clearer in the workbook I need count in the row D4:AO4 but if any question I will try to answer.

Please help.

Regards,
Moti

@JohnTopley I like the both macros superb! And the both options worked fine. Excellent solutions!

I appreciate you for your help. Good luck.

My Best regards,
Moti

@daboho, your code is extraordinary! It recognizes the length of each group automatically and generates all combination as per min-max input multiplying group’s correctly Brilliant idea! (This way one code covers both options!) This is solved 100%...

I appreciate you for your help. Good luck.

My Best regards,
Moti

@JohnTopley, I got it you are correct but there is any way after 1M rows can continue to next columns is it possible?

My Best regards,
Moti

Originally Posted by JohnTopley

Of course it can be done, BUT of what practical use is 4M + rows of data?

@JohnTopley, my honest answer is may be not after looking into it or may be useful I am not sure…May I request you if it can be done. Please can you create it for me.

My Best regards,
Moti

Originally Posted by JohnTopley

Please Login or Register  to view this content.

Resultant file is far too big to upload:

@JohnTopley, hats off to you I am amazed how you create this entire complicate task. This worked fine got fully results in 5:23 minutes.

I am grateful thank you for your support and providing a perfect answer. This one is solved 101%!

Originally Posted by JohnTopley

You are chasing "ghosts" with all this!

I am agreeing you are absolutely right…sometime really I find It's similar to chasing Shadows or chasing the wind. All my efforts that lead nowhere….

Have a lovely evening.

My Best regards,
Moti