How would I find the total number of combinations for any given group sets? For instance:
I have 5 fields,
Field A, B, C, D, and E.
A, D, and E need to be filled with 1 number. B and C need to be filled with 3 non repetitive numbers.
Field A and E can be 1 - 4, B can be 1 - 16, C can be 1 - 10, and D can be 1 - 11. Like this:
Category A B C D E
How many 1 3 3 1 1
Choices 4 16 10 11 4
So obviously the first possible outcome would be something like:
A - 1 B - 1,2,3 C - 1,2,3 D - 1 E - 1
Hopefully it makes sense and you can see that each columns choices are independent of each other, when this is in practice it will actually be unique names. If someone could help me out with a formula that would be fantastic. Thank you very much.
So then in order to get all possible combinations of each, do I just multiply all of that together to get 11,827,200?
– Michael Oct 07 '15 at 00:47