bekirsahin
New Member
- Joined
- Feb 28, 2018
- Messages
- 5
I have a problem regarding to excel binary combinations. As you see there is a matrix (Matrix 1) with the values of 1 and 0. --- represents N/A or 0. I want to get all different combinations without changing the sums.
Matrix 1:
<tbody>
</tbody>
For example, below is a different combination of the Matrix 1. Red ones are the only changed numbers and the sums never changed.
<tbody>
</tbody>
I appreciate your effort.
Thank you very much
Sincerely
Matrix 1:
Sum | ||||||
--- | 1 | 0 | 1 | 0 | 2 | |
1 | 1 | 1 | 1 | 0 | 4 | |
1 | 0 | 1 | --- | 0 | 2 | |
1 | --- | 0 | --- | 1 | 2 | |
1 | --- | 0 | --- | 1 | 2 | |
1 | 1 | 1 | 0 | --- | 3 | |
1 | 1 | 1 | 0 | --- | 3 | |
0 | 1 | 1 | 0 | --- | 2 | |
1 | 1 | 1 | 1 | --- | 4 | |
Sum | 7 | 6 | 6 | 3 | 2 | 24 |
<tbody>
</tbody>
For example, below is a different combination of the Matrix 1. Red ones are the only changed numbers and the sums never changed.
Sum | ||||||
--- | 0 | 1 | 1 | 0 | 2 | |
1 | 1 | 1 | 1 | 0 | 4 | |
1 | 1 | 0 | --- | 0 | 2 | |
1 | --- | 0 | --- | 1 | 2 | |
1 | --- | 0 | --- | 1 | 2 | |
1 | 1 | 1 | 0 | --- | 3 | |
1 | 1 | 1 | 0 | --- | 3 | |
0 | 1 | 1 | 0 | --- | 2 | |
1 | 1 | 1 | 1 | --- | 4 | |
Sum | 7 | 6 | 6 | 3 | 2 | 24 |
<tbody>
</tbody>
I appreciate your effort.
Thank you very much
Sincerely