how to generate combinations in excel

**harleydats** · 07-20-2010, 02:45 AM

I want to generate all possible combinations of 11 combination 4. I know there are 330 possible combinations but how can i let excel generate all the combinations. 1-11 combination 4.

For example. 1 2 3 4 5 6 7 8 9 10 11 taking 4 at a time:
1234
1235

**martindwilson** · 07-20-2010, 07:03 AM

is this letters or numbers?
there is a handy tool here
http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm
although it specifies letters you can use 0-9 as well

there is also this code from myna larson
put C in A1 (c for combinations p for permutations).
4 in A2 ((the number of combinations you want)
1-11 in A3:A13 (or 11 diferent text items if you want)

run the macro ListPermutations a new sheet will be added with all the combinations.

note apparently in excel 2007 you need to replace

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

this is the full code

Please Login or Register  to view this content.

**kumaroffice** · 03-07-2015, 06:03 AM

The code in this article can intake upto 8 characters and generates all possible words. Same way, you can input the numbers in this input and get possible combination of numbers. This is kind of Brute force basic algorithm, used for Word combination generator as well. Click here to check the article.

**kumaroffice** · 03-07-2015, 06:10 AM

The code in this article can intake upto 8 characters and generates all possible words. Same way, you can input the numbers in this input and get possible combination of numbers. This is kind of Brute force basic algorithm, used for Word combination generator as well. Click here to check the article.

**kumaroffice** · 03-07-2015, 06:29 AM

The code in this article can intake upto 8 characters and generates all possible words. Same way, you can input the numbers in this input and get possible combination of numbers. This is kind of Brute force basic algorithm, used for Word combination generator as well. Click here to check the article.

**kumaroffice** · 03-07-2015, 06:55 AM

The code in this article can intake upto 8 characters and generates all possible words. Same way, you can input the numbers in this input and get possible combination of numbers. This is kind of Brute force basic algorithm, used for Word combination generator as well. Click here to check the article.