Generate or Create all Possible Combinations Permutation from Single Column with Excel Formula

Learn how to genrate all possible combination and Permutation with a very easy formula using Excel 365 for single column.
Unlike Create all possible combinations of two lists of values in Excel, this video is focusing on single column.

Many expert using Power query to genrate combinations like "Get all possible combinations from multiple lists in Excel using Power Query | Excel Off The Grid but that is not quickly refresh and requried a bit more steps.
Leila Gharani also explain but that is not for single column.
Also MyOnlineTrainingHub has concept about this but this formula is much simple
so far Kenji Explains don't have a good video to explain this concept.
ExcelIsFun and Excel on Fire have not a new version video on this topic.

After learning this simple Excel formula you don't need a template to make all possible combination like " Combinations Generator - Free Excel Template"

===CHAPTERS===
0:00 Intro
0:57 Building main All possible combinations formula
7:08 Getting 1-1 Unique combination
8:25 Final Formula (real world data)

I hope you like this video. Please subscribe the channel for support :) Thank you so much.

File link:

[MatteoDallaRovere-gh]

sir, this is exactly what I was looking for! Thank you! however I got an error, when trying to use the Lambda and vstack formula. What are "A" and "R" in those 2 formulas? When I hit enter for the formula I got a #NUM! error. Thanks for any help!

[dimokenchev]

Thanks, this is very useful, but how do I make it work to also show results like B-A, D-A, etc. as this one seem to only work to the left, and not backwards.

[hagiasofia]

Dear good sir, this is brilliant, thanks for that! Not long time ago I wrote a formula to generate combinations but this one far simpler, faster and more universal...

[eeman]

i like it make more vedios like this👍😊

[mrbashr]

What if just two or just three combination not all ?

[LyubomirRusanov]

Elegant solution, but does not generate all possible permutations.

[fredphlogiston]

I have a better solution. Make out of INPUT a table with the name INPUT. And then use this formula:

Obviously for the 1-1 Unique Combination.