Hi shg, I am trying to understand the "possible combinations" thread you posted/answered back in 2009.
Hi shg, I am trying to understand the "possible combinations" thread you posted/answered back in 2009.
Last edited by JBeaucaire; 02-28-2014 at 06:40 PM.
And your question is ...?
Entia non sunt multiplicanda sine necessitate
shg,
I am needing to do something very similar to what was discussed in the 2009 threads/postings.
Would that routine/code be the same for obtaining the numerical combinations for the following variables?
S = A + Y + M
For example, when S = 4:
A Y M
0 0 4
0 1 3
0 2 2
0 3 1
0 4 0
1 0 3
1 1 2
1 2 1
1 0 3 etc …
I am needing to do this for S and S can be an integer from 1 - 400. I don't mind having to run the routine 400 times but getting the combinations would be quite laborious and prone to error.
Your expertise will be Much appreciated.
XGA
And what happens when you run the exact code posted?
These posts are moved to a thread of their own as per forum rules. There is a link to the source content you are referencing in the first post.
Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks