Generate all possible combinations

Hi

Are there some way to generate all possible combintations from columns , example below

combinations.jpg



But I can to have more columns and rows, example I would like all combintations with 56 columns and each column have 2 rows, may be I have to save a textfile

Is there some way to do it ?


Thank you in advance

with MOD and ROW, it shouldn't be too hard.

If you post the spreadsheet as an XLS(X) instead of just a JPEG screencap, I (or someone else) could turn that around for you.

Thank you , but how can I to upload it ?

Reply => Go Advanced => scroll down to Additional Options and click the "Manage Attachments" button
Then "Add Files" and select the spreadsheet

combina.xls

Thank you

I would like something like then columns AD....BE in sheet "01_56".
I have 56 columns , and two rows , I want to generate all combinations each row of column with each row all columns, inside there are a procedure ListCombinations , but using array did not work when there are many numbers

Thank you

May be to save a textfile