Using Excel2000
Hi,
Till now I was using "pgc01 code" which is amazing, I found code under this link
https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848
I require modifications code only output Permutation Repetition with a desire sums
For example...
In the cells B6:B10 there are numbers 0,1,2,3,4,5 I need all Permutation Repetition could be find with SUM = 43. Is it possible?
Layout is not important could be the any way depending on the new or modified code
Data example....
Thank you in advance
Regards,
Kishan
Hi,
Till now I was using "pgc01 code" which is amazing, I found code under this link
https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848
I require modifications code only output Permutation Repetition with a desire sums
For example...
In the cells B6:B10 there are numbers 0,1,2,3,4,5 I need all Permutation Repetition could be find with SUM = 43. Is it possible?
Layout is not important could be the any way depending on the new or modified code
Data example....
| Book1 | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
| 1 | P | 14 | * | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 2 | 4 | 2 | 4 | 4 | 4 | 1 | 43 | |||
| 2 | Combinations | FALSE | * | 2 | 2 | 4 | 3 | 2 | 3 | 2 | 3 | 3 | 4 | 5 | 3 | 3 | 4 | 43 | |||
| 3 | Repetition | TRUE | * | 5 | 2 | 1 | 4 | 3 | 2 | 3 | 2 | 3 | 4 | 4 | 3 | 2 | 5 | 43 | |||
| 4 | * | * | * | 5 | 3 | 5 | 3 | 2 | 5 | 4 | 4 | 1 | 1 | 1 | 3 | 4 | 2 | 43 | |||
| 5 | Set Col B5 Down | 0 | * | 4 | 2 | 4 | 5 | 4 | 3 | 2 | 3 | 3 | 3 | 1 | 3 | 4 | 2 | 43 | |||
| 6 | * | 1 | * | 2 | 4 | 2 | 2 | 3 | 5 | 4 | 3 | 4 | 3 | 4 | 3 | 1 | 3 | 43 | |||
| 7 | * | 2 | * | 3 | 1 | 4 | 2 | 3 | 4 | 3 | 3 | 5 | 5 | 1 | 4 | 4 | 1 | 43 | |||
| 8 | * | 3 | * | 3 | 2 | 2 | 2 | 5 | 4 | 1 | 5 | 3 | 4 | 3 | 2 | 3 | 4 | 43 | |||
| 9 | * | 4 | * | 2 | 3 | 5 | 3 | 4 | 5 | 4 | 1 | 4 | 4 | 1 | 1 | 2 | 4 | 43 | |||
| 10 | * | 5 | * | 5 | 3 | 1 | 4 | 3 | 4 | 4 | 4 | 4 | 2 | 3 | 1 | 1 | 4 | 43 | |||
| 11 | * | * | 3 | 3 | 5 | 1 | 2 | 2 | 4 | 4 | 3 | 1 | 5 | 3 | 3 | 4 | 43 | ||||
| 12 | * | * | 5 | 0 | 4 | 5 | 3 | 5 | 3 | 2 | 1 | 3 | 5 | 1 | 2 | 4 | 43 | ||||
| 13 | * | * | 2 | 3 | 3 | 5 | 1 | 4 | 2 | 3 | 2 | 2 | 5 | 4 | 3 | 4 | 43 | ||||
| 14 | * | * | 2 | 3 | 3 | 4 | 4 | 5 | 2 | 2 | 3 | 2 | 2 | 3 | 3 | 5 | 43 | ||||
| 15 | * | * | 1 | 3 | 1 | 3 | 5 | 1 | 4 | 3 | 4 | 5 | 3 | 3 | 4 | 3 | 43 | ||||
| 16 | 4 | 2 | 4 | 2 | 4 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 2 | 43 | ||||||
| 17 | 1 | 4 | 1 | 3 | 4 | 5 | 5 | 2 | 3 | 3 | 4 | 3 | 2 | 3 | 43 | ||||||
| 18 | |||||||||||||||||||||
| 19 | |||||||||||||||||||||
Sheet1 | |||||||||||||||||||||
Thank you in advance
Regards,
Kishan
Last edited:
