Combinations

[Chris_t_2k5]

Hi, I am using the numbers 1 to 15. I need to calculate all the combinations
within these numbers to create 5 sets of 3 numbers

eg. 1 2 3, 4 5 6, 7 8 9, 10 11 12, 13 14 15
eg. 1 2 4, 3 5 6, 7 8 9, 10 11 12, 13 14 15

so all of the 15 numbers have to be used up each time

Thanks

[Del]

Have a look at either the =PERMUT() or =COMBIN() functions.

"Chris_t_2k5" wrote:

> Hi, I am using the numbers 1 to 15. I need to calculate all the combinations
> within these numbers to create 5 sets of 3 numbers
>
> eg. 1 2 3, 4 5 6, 7 8 9, 10 11 12, 13 14 15
> eg. 1 2 4, 3 5 6, 7 8 9, 10 11 12, 13 14 15
>
> so all of the 15 numbers have to be used up each time
>
> Thanks

[millsy]

There are 1.3 x 10^12 permutations of 15 numbers. If you want to cover all possibilities I doubt that there is a spreadsheet big enough to hold the results.

You might need to tackle your problem a different way.