Create all possible combinations for three numbers

[YasserKhalil]

Hello everyone
I need to create all possible combinations for those three numbers 1 , 2 and 3 ... in 6 rows
I have put some of expected output in the attachment

Thanks advanced for help

[davsth]

with formulas copy the following accross 729 (3^6) columns
row 1 =TRUNC((COLUMN(A1)-1)/3^5)+1
row2 =MOD(TRUNC((COLUMN(A2)-1)/3^4),3)+1
row3 =MOD(TRUNC((COLUMN(A3)-1)/3^3),3)+1
row4 =MOD(TRUNC((COLUMN(A4)-1)/3^2),3)+1
row5 = MOD(TRUNC((COLUMN(A5)-1)/3),3)+1
row6==MOD(COLUMN(A1)-1,3)+1

[YasserKhalil]

Thanks a lot for your great solution
I need a VBA code for that .. as I need to store results in an VBA array first
Best Regards

[davsth]

You have not said how you want the information held in an array and what you wish to do with it. It makes hard to know what you want as an answer. To create the values with Vba is easy as its just 6 nested loops

Please Login or Register  to view this content.

I will let you add the array bit where you see fit

[YasserKhalil]

Thank you very much Mr. Davsth
You are great and thanks for your time
Regards