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, I am sorry, I guess it's a little hard to explain it. I appreciate all your help.
I am not trying to combine cells.
I need to know all the combinations of the given numbers, here is a picture of how I did some of it manually. Let me know if that is clear.
I am not trying to combine cells.
I need to know all the combinations of the given numbers, here is a picture of how I did some of it manually. Let me know if that is clear.
I am not sure where to upload the photo, I am having a hard time here.
- 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- 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.
