Forum Discussion
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
7 Replies
- mathetesSilver Contributor
I'm going to have to noodle and doodle on this a bit.
Do you really expect every possible combination of five digits, using just one from each column? And how many rows are we needing to accommodate? If numbers can be entered randomly in the various columns, is it permissible to have duplicates in any of the combinations? Etc.
In the meantime, can you tell me (and anybody else looking over our shoulders) what the context is, the "bigger picture," for this request. That, in addition to your re-written instructions, may help in the understanding.
And, for anybody looking over our shoulders, this thread actually is a continuation of this one :
- rachelSteel ContributorI think he just wants to do Cartesian product five times. eg
col_12 = torow(col1 & transpose(col2))
col_123 = torow(col_12 & col_3)
col_1234 =torow(col_123 & col_4)
col_12345 = torow(col_1234 & col_5)- Marco365Brass ContributorHello Rachel, thank you for taking time to help me. I am hoping to take a bootcamp this year and excel is part of it. As of now, I am not sure how to apply this. I did attach a file and I am not sure if this can apply to the sheet. I am going to google the keyword "cartesian" to see what I can learn. Thanks