# combination making in excel

#### rize1159

##### Board Regular
Dear I am doing some sort of experimental design problem. I going to give breife overview here.

I have a process of 14 parameters which can affect final product. let they are a, b, c ......., I have to make combination of five parameters, such that probability of selection of one parameter is only two i.e I can select parameter "a" two times e.g I have combination "aabcd"; combinations like "aaabc" or "abbbc" are not allowed.

Now each parameter has some probability of occurance lets suppose 1,2,3,4,5 etc assigned against it. Secondaly each parameter has a level of severity similar to above i.e 1,2,3,4,5....

What I want is when I give a list of 14 parameters in A1 to A14, their probability in B1 to B14, and severity in C1 to C14, excel should make all possible combinations of 14 parameters and each set should be of 5 parameters along with their probability and severity.

I have excel 2007. Your help in this regard will be highly appreciated.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### rize1159

##### Board Regular
Can Anyone help me out in this

Replies
11
Views
604
Replies
3
Views
259
Replies
0
Views
419
Replies
6
Views
1K
Replies
1
Views
371

1,191,123
Messages
5,984,780
Members
439,910
Latest member
Flyingjoblo

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