Hello everyone,
I'm new on excel (honestly I'm not into it, just need it), and I have a question about code.
For my master thesis I need a map (or a matrix) of all possible combinations of numbers between 0. and 1. (with an increment of 0.1) powered to 60
confusing?:
Imagine 60 columns, and each cell of each column can store a number between 0 and 1:
[0; 0.1; 0.2; 0.3; 0.4; 0.5; 0.6; 0.7; 0.8; 0.9; 1]
I need any possible combinations between all columns values. I understand this maybe not possible because it will end up with a huge number of rows. For a start, it would be acceptable 10 columns.
My Question: I found this solution on this forum from the user @TMS:
http://www.excelforum.com/excel-gene...variables.html
But I can't make it work. The error is: Run-time error '9': Subscript out of range
Can somebody help me? Is there any useful tutorial I can start with? I'm using office 2016 for Mac.
My knowledge of coding is Processing and MAX/MSP, so, a long way from home.
Thank you very much!
Best Regards
Bookmarks