Code by Myrna Larson that does this:

http://tinyurl.com/cdjck

--
Regards,
Tom Ogilvy

"tx12345" <tx12345.1rz52a_1121033100.7693@excelforum-nospam.com> wrote in
message news:tx12345.1rz52a_1121033100.7693@excelforum-nospam.com...
>
> Hi
>
> I have a simple question I think, just not sure how to go about it.
>
> Let's say I have a row of numbers:
>
> 1 2 3 4 5 6 7 8 9 10 11 12 13 14
>
> and let's say I want to display on the spreadsheet all the possible
> combinations of 2 numbers:
>
> 1-2, 1-3, 1-4, etc
>
> OR let's say I want to see all the possible combinations of 3 numbers:
>
> 1-2-3, 1-2-4, 1-2-5, etc
>
>
> I have done this manually, but I am guessing there is a better way.
>
> TIA!
>
>
> --
> tx12345
> ------------------------------------------------------------------------
> tx12345's Profile:
http://www.excelforum.com/member.php...o&userid=24776
> View this thread: http://www.excelforum.com/showthread...hreadid=385992
>