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