Let's say, I've got an 3 x 3 matrix. I want all the combinations of the table entries such that, a combination
C1 = [R1C1] x [R2C1] x [R3C1]
C2 = [R1C1] X [R2C1] X [R3C2]
C3 = [R1C1] X [R2C1] X [R3C3]
C4 = [R1C1] X [R2C2] X [R3C1]
C5 = [R1C1] X [R2C2] X [R3C2]
C6 = [R1C1] X [R2C2] X [R3C3]
C7 = [R1C1] X [R2C3] X [R3C1]
C8 = [R1C1] X [R2C3] X [R3C2]
C9 = [R1C1] X [R2C3] X [R3C3]
C10 = [R1C2] X [R2C1] X [R3C1]
C11 = [R1C2] X [R2C1] X [R3C2]
C12 = [R1C2] X [R2C1] X [R3C3]
C13 = [R1C2] X [R2C2] X [R3C1]
C14 = [R1C2] X [R2C2] X [R3C2]
C15 = [R1C2] X [R2C2] X [R3C3]
....and so on. For a 3X3, there would a total of 27 combinations.
The algorithm should work for nxm matrix.
The matrix would be an input table in excel. The excel macro should generate these combinations and should display these combinations in a list below the table.
The output list will have 2 columns. 1st column will have combination Id, 2nd column will have the combination value. Combination Id is a string showing which positions were multiplied to get that combination. For eg. in the example above, the first combination id would be 1-1-1 and combination would be C1 value. next would be [1-1-2, C2], then [1-1-3, C3], [1-2-1 C4] etc..
20 freelancers are bidding on average $34 for this job
Hello I have over 17 years of experience in various areas of IT technologies and programming languages. Also, I have strong mathematical background and I have experience with writing Excel macros using VBA
Dear sir, By profession i’m an engineer and has sound knowledge about matrixes and its behavior.i can develop solution for this [login to view URL] contact me. Thank you.
I have a well experience in excel Work for others is a pleasure for me. I would not disappoint u. It would be a great honor for me to work for u.........I hope u will hire me for your project......