Possible combinations

[synergy16]

good morning all. i need some assistance with a VBA sub that takes X elements in a column and returns all possible combinations of those. order does not matter BUT i dont want repeats of the same grouping, and the grouping can be 1 element to X elements. so in otherwords, the X elements are operations done to a part. some parts will have all operations done some will have 1 operation done. so what returns from the sub will be a list of all possible ways a part can be worked on.

 

[Joe4]

Have a look here: List All Possible Excel Combinations From a Single Column

 

[synergy16]

Have a look here: List All Possible Excel Combinations From a Single Column

perfect. thank you Joe4

 

[Joe4]

You are welcome!

 

[Eric W]

Sounds like you have a solution, but here are a few more options:

Need all unique combinations of a single column

I need to create a list of unique name combinations from a single column, for example: Mary Jim Henry Candy And output all unique combinations but also grouped up to the number of names. E.G. Mary + Jim, Mary + Jim + Henry, etc. The name column may vary in total names. Perhaps output one...

www.mrexcel.com