Thread: Combinations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris_t_2k5
 
Posts: n/a
Default Combinations

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