View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default combining numbers into combinations


I have a set of x amount of numbers.... sometimes 10 some times 8.. I would
like to take those numbers and generate every possible 5 number combination.

ie.

A B C D E F G H
--- --- --- --- --- --- --- ---
1 2 3 4 5 6 7 8


A B C D E
--- --- --- --- ---
1 2 3 4 5
1 2 3 4 6
1 2 3 4 7
1 2 3 4 8
1 2 3 5 6
1 2 3 5 7
1 2 3 5 8

It would be on the same sheet (lets call it Sheet3)
Thank you for helping me.