Forum Discussion
See attached
I am not able to post this, maybe it will post eventually. It keeps asking me to correct highlited errors but cant find any
- Try this formula if you have MS365:
=TOCOL(TOROW(TOROW(TOROW(TOROW(A1:A5)&"-"&B1:B5)&"-"&C1:C5)&"-"&D1:D5)&"-"&E1:E7)
Also, I think you can just edit this post instead of creating a new one.
Creating new posts creates confusion.
I had to look at both of your posts to figure out that you don't need to SORT numbers by "ascending order" explicitly, as numbers in column 2 is always greater than numbers in column1, column 3 is always greater than column2....
All you need is just combination.
Thank you, next time I will try to stick to one post and add more details. I thought it would bring less confusion.
I entered this formula on MS365 online, and it gives me a bunch of pound signs. Maybe I am doing something wrong.
I entered this formula on MS365 online, and it gives me a bunch of pound signs. Maybe I am doing something wrong.
I attached the file.
Formula in column N9.
The idea is like this:
See the first answer.
- I am not sure what the context is. but I saw similar questions asked elsewhere. Not combinations of numbers, but combinations of product model, colours etc. for example, ProductType = iPhone15, iPhone16; Model = Pro, Plus, MaxPro; Colours = Blue, Pink, Green, Black. Find all combinations of possible iPhones. and I saw some genius uses this Cartesian Product to do this. so some common sense and not-so-wild guess make me think that this must be what OP is after here too.
Thanks for that solution. I'm not sure how you were able so quickly to deduce that what Marco365 was seeking was the Cartesian Product.....but that said, I'm still left wondering what kind of context--what kind of practical application--this would ever have. Do you have an example of how this would be used in any setting other than in the mind of Rene Descartes?
