#### MikeGraves

##### New Member
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.

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### cyrilbrd

##### Well-known Member
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

##### New Member
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

##### Well-known Member
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

##### New Member
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.

Replies
4
Views
212
Replies
6
Views
305
Replies
3
Views
219
Replies
6
Views
303
Replies
15
Views
353

### Forum statistics

1,191,485
Messages
5,986,861
Members
440,055
Latest member
CraigTriesHisBest

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back