All possible combinations between 11 numbers

With your Data there can only be 121 combinations.
Unless I misunderstand.

paste this formula into A1 and fill to the right to K1

then fill down to K11.

Formula:

Please Login or Register  to view this content.

Or run this Macro

Please Login or Register  to view this content.

With 11 columns you would need 11^11 rows.

Excel does not support that.

You would need to print that a page at a time.

For 10 columns, that's 11^10 arrangements.

The file would be over 100 GB, but Excel would fall over way before you got there.

Why do you think you need this?

Hi all.
My work is about sound synthesis.
I need a map of all possible combinations of virtual synthesizer's parameters. Then, my program will analise those combinations according to some sound descriptors.
Sound descriptors are metaphorical expressions that can help us perceive sounds.

The main idea behind this is to make neural networks learn what a 'bright' or "smooth' sound is, in order to replicate real sounds with sound synthesis.
I know, is ambitious... But I tend to simplify all this.

I was able to make a .txt file with all possibilities for only 9 columns and 5 different numbers.
140mb...

I thought excel would help me solve this.
Thank you all, though

Best Regards

I ran this for 1000, 000 loops and got to this:

0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.1
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.2
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.3
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.4
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.5
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.6
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.7
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.8
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 0.9
0 0 0 0 0 0.6 0.2 0.3 0.3 0.4 1


I used this Code, the message box appears every 100,000 loops and asks if you want to continue:-

Please Login or Register  to view this content.

Ok I have a solution for you.

Run this Macro:

Please Login or Register  to view this content.

During my trials I ran 1000 000 rows at a time ang to to about 4000 000 without any issues.

However my laptop ran out of memory before the end.

Tell me if your mac does as well in which case give me a folder address and I will modify the macro to save the results in a seperate file for each million results.

This code has been modified to let you see that is happening.
It Saves each completed column into the same folder as your macro file.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.