Generate sets of five numbers base on the given numbers from 5 different columns
I color them just to show that the numbers stay in the same column, and still are in ascending order.
Columns H to L or just N are a few examples of combinations I did manually to show the results I am looking for.
Columns A to E, the given numbers, should generate all the possible combinations as you see in H to L or just N.
I do not want to mix the columns like in P1
Let me know if you have any questions.
I attach the excel file
Thank you for your help
I color them just to show that the numbers stay in the same column, and still are in ascending order.Columns H to L or just N are a few examples of combinations I did manually to show the results I am looking for. Columns A to E, the given numbers, should generate all the possible combinations as you see in H to L or just N. I do not want to mix the columns like in P1 Let me know if you have any questions. I attach the excel file Thank you for your help Read More