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.
mathetes
Maybe I wasn't clear, so I went and create another one with heading, photos, and more details.
I hope it's clear or clearer. Here is the link for it below. I really appreciate your help.
https://techcommunity.microsoft.com/t5/excel/generate-sets-of-five-numbers-base-on-the-given-numbers-from-5/m-p/4126736#M227991
Maybe I wasn't clear, so I went and create another one with heading, photos, and more details.
I hope it's clear or clearer. Here is the link for it below. I really appreciate your help.
https://techcommunity.microsoft.com/t5/excel/generate-sets-of-five-numbers-base-on-the-given-numbers-from-5/m-p/4126736#M227991
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.
=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.
- 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?
- I will look into it. Thank you Rachel
- If you are on Mac, best chance would be formula. E.g search “how to find all combinations of two lists in Excel using formulas”. There should be non-365 formulas available.
- I am so sorry for making you work so hard. I kept trying and it finally worked. It was me who couldn't figure it out the first time. It works but on the online version of MS365.
Base on your keyword I did find a simple video. It shows how to get it done but without a formula, I couldn't find the options on the MAC version.
Thanks a bunch. I attached the file.
Formula in column N9.
The idea is like this:
See the first answer.
- 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.
