Dear All,
I am trying to generate a table for the following
I have 12 Columns
Jan Feb March Apr May etc....
Each month has minimum to maximum value i.e.
Jan Feb
Min - 7 Min - 6
Max - 11 Max - 8
and I have put the values (Max,Min and all in between) in columns like below.
Jan Feb
7 6
8 7
9 8
10
11
What I am trying to work out is how I can generate a table with all the combinations of numbers (Horizontal) from all the columns that add up to a certain value (i.e. 100).
In total there will be 136080000 different combinations, what I am interested in is
1) How many combinations will add up to a certain value (i.e. 100) and
2) What are those combinations
Thanks for your help.
Bookmarks