Display all combinations from a set of numbers

  • Thread starter Thread starter tx12345
  • Start date Start date
T

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!
 
Thanks, but the code is bugged out. buffer issues and other things. I
probably do not know how to use it.
 
.. 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!
 
Back
Top