Making Combinations in Excel

[nsbeluv]

Hi everyone,

I have a problem. I need to figure out all of the combinations to match 7 numbers in 2 groups (one of 4 ppl and one of 3 ppl). There are 35 different combinations I can have, but I'm only coming up with 17 when I try to do it by hand. There has to be a faster way in Excel.

The numbers are 68, 77, 82, 85, 53, 64, 71

I need all possible combinations of putting these 7 numbers in 2 different groups (4 numbers in one group and 3 in the second)

Thanks!

 

[shg]

Welcome to the board.

If you have four people in one group, and three in another, and want pairs with one person from each group, that's 4 x 3 = 12 combinations, isn't it?

 

[nsbeluv]

That's what I thought but the book says there will be 35 combinations

 

[shg]

There would be 35 if you had 7 in one group and 5 in the other. Maybe a little closer reading of the book would make clear that you and it aren't thinking about the same thing.