Excel Number Combinations (addition)

[MikeGraves]

Hi, im sorry if this is a beaten subject but after reading 100 threads, i cant find what i need.
Can someone please tell me how to:

a) I have 40 numbers (percentages)
b) I need every outcome of these 40 numbers (added together) in groups of 6
(so example, 1+2+3+4+5+6, 1+2+3+4+5+7..... to the last potential sequence i guess, 35+36+37+38+39+40)

So example

1 0.100
2 0.214
3. 0.117
...
40 0.225

What is important for me is to have these located within a range.

i.e. High 1.5 Low 1.2 (i can search this , its no issue, index match function will do)

but i need the macro or formula to create it without me doing 1.8m formulas.

Then be able to know, ok

1 3 4 21 22 39 (in range) (obviously the numbers are added)
3 24 16 12 18 40 (in range) (obviously the numbers are added)

Is there some simple (i.e. non genius solution) any one can share. I have read dozens of posts, and while some touch upon this subject, its all different.

Id really really appreciate some help/guidance. Thanks everyone.

 

[cyrilbrd]

Hi, that would be 3,838,380 combinations such as:

6	5	4	3	2	1
7	5	4	3	2	1
8	5	4	3	2	1
9	5	4	3	2	1
10	5	4	3	2	1
11	5	4	3	2	1
12	5	4	3	2	1
13	5	4	3	2	1
14	5	4	3	2	1
15	5	4	3	2	1
16	5	4	3	2	1
17	5	4	3	2	1
18	5	4	3	2	1

<tbody>
</tbody>

right?

 

[MikeGraves]

Yes that is correct.
I have 40 nodes of system. The problem is that at times, i need to find an optimum group inside that, which can have obviously multiple solutions.

So i need to be able to calculate all the millions and then isolate within a range, thus, giving 1-1000 possible outcomes.

Obviously the refined analysis will bring very small amounts of final numbers as it will be accurate to say 0.003.

If you can suggest or guide me, id be most most grateful.

Cheers

 

[cyrilbrd]

A formulae based combinations model could be created but I am doubtful about the cpu usage for such task... maybe a vba solution might be more appropriate?

 

[MikeGraves]

A formulae based combinations model could be created but I am doubtful about the cpu usage for such task... maybe a vba solution might be more appropriate?

I am open to any ideas, the problem is that its not needed to be printed moreso just outcome driven and then run a few filter solutions.

if even i can create a data stream of the outcomes, it would be helpful.

I looked at all the VBA models, and none report with the information i need. hence needing guidance to how to make this work.