Limited Repeating Permutation Macro

[dlybb]

I have found some threads that are close to this question, but none that I have been able to modify for my needs. The question is this:

Say I have 3 object types a,b and c, where each has a quantity of x,y and z respectively.

I need to load all of the possible permutations into a matrix (not cells). In this case, I require permutations (as opposed to combinations).

I have never dealt with this type of code before (as in statistics).

 

[dlybb]

Thanks so much for your help. When (or if) I get a general solution to option 2 coded, I will try to remember to post it for anybody else who has this problem.

 

[dlybb]

So I have been messing around with the sheet (very nice by the way), and the number of calculations required for my application is simply too large (it is taking over 20 minutes for what I would consider a small data set). So, I think I will have to come up with a different method of solving this problem (as in not using perm's and com's). Thanks again for all of your help, it is back to the drawing board for me.

 

[shg]

When (or if) I get a general solution to option 2 coded, ...

The posted workbook is a general solution.

 

[dlybb]

Ya, sorry about that, I noticed that by the next comment.