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

...function I use to calculate the number of combinations

The number of combinations should be
2^6 = 64

= = =
HTH
Dana DeLouis



The Deacon wrote:
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

Hi,

Take a look at the COMBIN function. (and the PERMUT function).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"The Deacon" wrote:

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