Function/Array for combinations of numbers

[Karnik]

Hi Experts
Function to use numbers in a rows to give combinations


Objective is to make combination (small to larger) for following
2 7
3 6
1 4 8

only one number from each above rows & smallest to big
1 2 3
2 3 4
2 3 8
1 3 7
3 4 7
3 7 8
1 6 7
4 6 7
6 7 8

Thanks
Karnik

[Kaper]

Do you realy need to have it done with formulas?
Will be not that easy (in my opinion).
While VBA solution shall be rather strightforward.

[Karnik]

Hi Kaper,

Thank you for addressing my issue. I am novice for VB.
Request please suggest the solution using VB, it may save lot of time without any errors that I face currently

Thank you once again


Karnik

[Kaper]

Hi,
Have a look on such code, I made earlier for our national Forum
http://www.excelforum.pl/topics3/kom...ow-vt64868.htm
(and before used here: https://www.excelforum.com/excel-pro...vba-macro.html )
I just added sorting.

It reqiures other orientation of data (in columns not in rows, starting in cell B3) but of course you can copy with transpose.

Please Login or Register  to view this content.

See sample file attached

[Kaper]

PS. As you may prefer original layout, and mentioned that have limited VBA knowlegde - please find version adopted to original data layout:

Please Login or Register  to view this content.

[Karnik]

Hi Kasper,

Thank you VB. This is brilliant VB saves huge amount of time..
Cheers
Karnik