Combinations Generator with Macros

Need an Excel combinations generator that can generate combinations into a list from multiple numbers.

Need an input, numbers will have commas between them, for example (9,12,21,22,29,40). Input numbers 6* and need output of 3 numbers. the result should look like this list.

Have the option for output, how many numbers of combinations to choose from. input can be up to 20 numbers and output can be from 1-19.

9,12,21

9,12,22

9,12,29

9,12,40

9,21,22

9,21,29

9,21,40

9,22,29

9,22,40

9,29,40

12,21,22

12,21,29

12,21,40

12,22,29

12,22,40

12,29,40

21,22,29

21,22,40

21,29,40

22,29,40

When multiple inputs are present, they should look like this.

Input*

9,12,21,22,29,40

5,18,30,41,46,52

11,14,19,33,44,54

output*

9,12,21

9,12,22

9,12,29

9,12,40

9,21,22

9,21,29

9,21,40

9,22,29

9,22,40

9,29,40

12,21,22

12,21,29

12,21,40

12,22,29

12,22,40

12,29,40

21,22,29

21,22,40

21,29,40

22,29,40

5,18,30

5,18,41

5,18,46

5,18,52

5,30,41

5,30,46

5,30,52

5,41,46

5,41,52

5,46,52

18,30,41

18,30,46

18,30,52

18,41,46

18,41,52

18,46,52

30,41,46

30,41,52

30,46,52

41,46,52

11,14,19

11,14,33

11,14,44

11,14,54

11,19,33

11,19,44

11,19,54

11,33,44

11,33,54

11,44,54

14,19,33

14,19,44

14,19,54

14,33,44

14,33,54

14,44,54

19,33,44

19,33,54

19,44,54

33,44,54

Results should all be in one column with no breaks.

Excel Visual Basic Databehandling Dataindførsel Software Arkitektur

Projekt ID: #38006882

Om projektet