I'm sure this has been asked before....

[David]

but I do not know what words to search on to find it.

I have a set of x amount of numbers.... sometimes 10 some times 8.. I would
like to geta macro that can 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 finding the code or helping me point to the location of the
right code.

David

[Bob Phillips]

http://tinyurl.com/cjor6

--

HTH

RP
(remove nothere from the email address if mailing direct)


"David" <[email protected]> wrote in message
news:[email protected]...
> but I do not know what words to search on to find it.
>
> I have a set of x amount of numbers.... sometimes 10 some times 8.. I
would
> like to geta macro that can 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 finding the code or helping me point to the location of the
> right code.
>
> David