All possible combination of one column list

[Robmalina]

Hi Experts,

I need a help from you on the below. I need to calculate all possible combination of the below:

"5L","5R","4L","4R","3L",3R","B2","B3","B4".

I would need a possible combination of 2 of each up to 9 of each and no duplicates.

I'm fairly new to excel so please forgive me if this is a stupid request and if there is already a thread for this please let me know.

 

[pbornemeier]

This post may work for you:
https://www.mrexcel.com/forum/excel...-list-all-possible-combinations-vba-code.html

This was interesting and can generate all of your answer in 8 iterations:
https://www.mathsisfun.com/combinatorics/combinations-permutations-calculator.html

 

[pbornemeier]

Another related post:
https://www.mrexcel.com/forum/excel-questions/564165-vba-code-multiple-combinations.html