Hi guys,
I need your help. Tried to check other post, but they don't exactly apply to my case.
So...
I have a list of names (let's say: A,B,C,D,E,F,G,H,I and J) and each one of them as a number - integer, (e.g. A-34; B-100; C-5; etc...) in another collumn.
Now, i would like to have a code that would publish all possible combinations taking into account 2 things:
- the Order of each letter matter;
- the sum of the numbers in each combination, cannot be more than 33;
- I might need to add letters (K, L, M, ...) and related numbers, frequently.
And if the Order restriction didn't apply, how would it be?
Thanks in advance for your help.
Any details, please be free to ask.
Best regards.
I need your help. Tried to check other post, but they don't exactly apply to my case.
So...
I have a list of names (let's say: A,B,C,D,E,F,G,H,I and J) and each one of them as a number - integer, (e.g. A-34; B-100; C-5; etc...) in another collumn.
Now, i would like to have a code that would publish all possible combinations taking into account 2 things:
- the Order of each letter matter;
- the sum of the numbers in each combination, cannot be more than 33;
- I might need to add letters (K, L, M, ...) and related numbers, frequently.
And if the Order restriction didn't apply, how would it be?
Thanks in advance for your help.
Any details, please be free to ask.
Best regards.
Last edited: