COMBINATIONS different group sizes

[dvb_24]

Hi, I'm trying to develop a macro that generates all the possible outcomes of 5 variables intervals combined between them, Could you help me with this?

1.The first problem I see is that the COMBINAT formula of excel works only for a constant number of alternatives for each variable but the number of elements in every interval is different for the different variables. Is the max number of alternatives in my example correct?

2. Could you help me to write the code to avoid repeating the outputs? By now roughly I have the following:

Please Login or Register  to view this content.

[dvb_24]

Can anyone at least give me an orientation of what I'm doing wrong?

[shg]

1. Yes, it is, but the formulas could be simplified.

In F3 and down, =IF(E3="", "", (D3-C3)/E3 + 1)

In F8, =PRODUCT(F3:F7)

2. What is the code supposed to do?

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

[dvb_24]

Thanks for replying, my aim is to write all the possible combinations between the 5 variables intervals.

For example, if v1 interval were from 0.8 to 0.85 with a step of 0.05 and v2 were from 18 to 10 with a step of 1 then

0.8 0.8 0.85 0.85
18 19 18 19

Those will be all possible combinations on both intervals

Let me know if I didn't explain that properly.

[shg]

dvb, please change the QUOTE tags to CODE tags.

[dvb_24]

Done! sorry about that

is my example clear enough?

[shg]

Do this do what you want?

[dvb_24]

Yes it does thanks but, is there any way to do it with code?