Combinations Generator with Macros
$10-30 USD
Pagado a la entrega
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.
Nº del proyecto: #38006882
Sobre el proyecto
9 freelancers están ofertando un promedio de $31 por este trabajo
Hello, I can perfectly assist you with that. I am an experienced Data Analytics professional. I hold years of experience in using SQL, Excel, Power BI and Tableau to perform Data Visualization and Data Analytics. To ma Más
Hello! I am confident and ready for you right now. Please contact me and let's discuss detail of your project. Sincerely. Le Huy.
I have been working now for 2 years as an excel/sheets Data Analyst, I trust I can do the task with a high flexibility on further modifications required. Happy to assist !