T
The Deacon
I am trying to find out which function I use to calculate the number of
combinations using a certain set of numbers.
For example - I have 12 numbers which consist of odd and even numbers. The
12 numbers represent 6 groups.
GRP 1 - 1,2
GRP 2 - 3,4
GRP 3 - 5,6
GRP 4 - 7,8
GRP 5 - 9,10
GRP 6 - 11,12
What I am trying to do is create combinations using one number from each
group that will create a group of 6 numbers in numerical order. (I hope this
make sense).
Example
The first couple of combinations would look like this -
1 2 1 1
3 3 4 3
5 5 5 6
7 7 7 7
9 9 9 9
11 11 11 11
So as you can see by the example the function would be used to create
combination regardless of how many numbers I use from the data I have. I
have only used a couple of the general functions in Excel and I just don't
where to look or how to create the function in excel.
The outcome of the combination will create an
combinations using a certain set of numbers.
For example - I have 12 numbers which consist of odd and even numbers. The
12 numbers represent 6 groups.
GRP 1 - 1,2
GRP 2 - 3,4
GRP 3 - 5,6
GRP 4 - 7,8
GRP 5 - 9,10
GRP 6 - 11,12
What I am trying to do is create combinations using one number from each
group that will create a group of 6 numbers in numerical order. (I hope this
make sense).
Example
The first couple of combinations would look like this -
1 2 1 1
3 3 4 3
5 5 5 6
7 7 7 7
9 9 9 9
11 11 11 11
So as you can see by the example the function would be used to create
combination regardless of how many numbers I use from the data I have. I
have only used a couple of the general functions in Excel and I just don't
where to look or how to create the function in excel.
The outcome of the combination will create an