Forum Discussion
Solved
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