Home

Simple List of Combinations From Single Row Table

%3CLINGO-SUB%20id%3D%22lingo-sub-128568%22%20slang%3D%22en-US%22%3ESimple%20List%20of%20Combinations%20From%20Single%20Row%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-128568%22%20slang%3D%22en-US%22%3E%3CP%3ENote%3A%20Novice%20User%2C%20using%20Excel%202013.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20non-repeating%20list%20of%20possible%20combinations%2Fpermutations%20from%20a%20single%20column%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20simple%20table%20called%20%22letters%22.%20The%20number%20of%20items%20will%20vary.%20I'm%20using%20alphabet%20characters%20in%20the%20example%26nbsp%3Bbut%20imagine%20these%20could%20be%20easily%20apples%2C%20oranges%2C%20salad%2C%20drink....and%20so%20on.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20110px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24270iB09BB9CD8DAED496%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%20excel%201.JPG%22%20title%3D%22Capture%20excel%201.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20separate%20tab%20I%20want%20to%20generate%20a%20list%20of%20non-repeating%20combinations%2C%20order%20does%20not%20matter%2C%20and%20I%20want%20to%20run%20this%20list%20in%20varying%20string%20length%20(1x%2C%202x%2C%203x%2C%204x%2C%20...)%20until%20final%20result%20with%20all%20items%20combined.%20Sample%20output%20I%20imagine%20would%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%3C%2FP%3E%3CP%3EB%3C%2FP%3E%3CP%3EC%3C%2FP%3E%3CP%3ED%3C%2FP%3E%3CP%3EAB%3C%2FP%3E%3CP%3EAC%3C%2FP%3E%3CP%3EAD%3C%2FP%3E%3CP%3EBC%3C%2FP%3E%3CP%3EBD%3C%2FP%3E%3CP%3ECD%3C%2FP%3E%3CP%3EABC%3C%2FP%3E%3CP%3EABD%3C%2FP%3E%3CP%3EBCD%3C%2FP%3E%3CP%3ECDA%3C%2FP%3E%3CP%3EABCD%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20possible%20from%20formatting%20perspective%2C%20I%20would%20like%20to%20display%20the%20combinations%20separated%20by%20%22%2B%22%20character.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20167px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24273i33D1503026FB6F65%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%20excel%202.JPG%22%20title%3D%22Capture%20excel%202.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-128568%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-129758%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20List%20of%20Combinations%20From%20Single%20Row%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-129758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGeneral%20answer%20-%20it%20shall%20be%20possible.%3C%2FP%3E%0A%3CP%3ESimilar%20cases%20are%2C%20for%20example%2C%20here%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F596215-listing-all-combinations.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F596215-listing-all-combinations.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.get-digital-help.com%2F2015%2F02%2F26%2Freturn-all-combinations%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.get-digital-help.com%2F2015%2F02%2F26%2Freturn-all-combinations%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20more%20concrete%2C%20how%20to%20do%20that%20in%20your%20concrete%20case%20-%20have%20no%20ready%20to%20use%20pattern.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-129709%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20List%20of%20Combinations%20From%20Single%20Row%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-129709%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20not%20possible%20in%20Excel%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881095%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20List%20of%20Combinations%20From%20Single%20Row%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881095%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir%2C%20I%20was%20searching%20solution%20for%20the%20same%20type%20of%20combination%20for%20last%20few%20days%2C%20searched%20everywhere%20but%20no%20result%20but%20now%20i%20hv%20solution%20because%20of%20you.%3CBR%20%2F%3Ethanks%20you%20heartly%3C%2FLINGO-BODY%3E
Peter Bedrosian
New Contributor

Note: Novice User, using Excel 2013.

 

I want to create a non-repeating list of possible combinations/permutations from a single column table.

 

I want to make a simple table called "letters". The number of items will vary. I'm using alphabet characters in the example but imagine these could be easily apples, oranges, salad, drink....and so on.

Capture excel 1.JPG

 

 

 

 

 

In a separate tab I want to generate a list of non-repeating combinations, order does not matter, and I want to run this list in varying string length (1x, 2x, 3x, 4x, ...) until final result with all items combined. Sample output I imagine would be:

 

A

B

C

D

AB

AC

AD

BC

BD

CD

ABC

ABD

BCD

CDA

ABCD

 

If possible from formatting perspective, I would like to display the combinations separated by "+" character.

Capture excel 2.JPG

 

Any help would be appreciated.

 

 

 

3 Replies

This is not possible in Excel??

Hi Peter,

 

General answer - it shall be possible.

Similar cases are, for example, here

http://www.excelforum.com/excel-general/596215-listing-all-combinations.html

https://www.get-digital-help.com/2015/02/26/return-all-combinations/

 

If more concrete, how to do that in your concrete case - have no ready to use pattern.

Thank you so much sir, I was searching solution for the same type of combination for last few days, searched everywhere but no result but now i hv solution because of you.
thanks you heartly
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies