Display all combinations from a set of numbers

[tx12345]

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!

 

[Tom Ogilvy]

Code by Myrna Larson that does this:

http://tinyurl.com/cdjck

 

[tx12345]

Thanks, but the code is bugged out. buffer issues and other things. I
probably do not know how to use it.

 

[Max]

.. but the code is bugged out. buffer issues and other things ..

No, definitely not. But you probably were hit by line wraps during copy >
pasting, etc when you tried to implement ..

So .. how about a nice, easy to use, working sample file with Myrna's
subroutine implemented ? The "Download File" link is available at:
http://flypicture.com?display=updone&id=qtr8kao=
File: MyrnaLarson_Combination_Permutation.xls

Right-click on "Download File" > Choose "Save Target As .." and save the
file to your desired folder. Open the file from there (Do not open the file
direct from the download link). You would need to enable macros, of course!

 

[Max]

http://flypicture.com?display=updone&id=qtr8kao=

The link given is good, but if you click directly, it may not work. Do a
copy > paste of the entire line (including the "=" at the rightmost end of
the line) into the address bar in the browser ..

 

[tx12345]

Great file, thank you very much

 

[Max]

You're welcome !

 

[Max]

Here's a new link to the sample file (previous one's gone):
http://savefile.com/files/4491071