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.
- I had to use Safari, I had tried a thousand time in google chrome and it would not work.
Here's at least part of a solution for you. This simple solution presumes that YOU take responsibility for entering the five numbers in ascending order. I'm sure we could devise a way to automate that too, but in the absence of a compelling reason to automate it, I chose to stick with "simple."
The formula in column N relies on converting the numbers in columns A through E to text.
=TEXT(A1,"0")&"-"&TEXT(B1,"0")&"-"&TEXT(C1,"0")&"-"&TEXT(D1,"0")&"-"&TEXT(E1,"0")It then concatenates those text values with the intervening hyphens, and repeats.
- Thank you for your help mathetes. I am wondering if I need to be more clear on the instructions. What I only need or the end goal is to have a formula or formulas to generate numbers base on the given numbers in column A to E. Column N gives a few examples of mixing them. Each column keeps their numbers, but all the rows in each column create sets of five numbers, in other words, rows from each column mix to create 5 numbers without leaving their column. The result should be smaller to higher. Notice how the first column numbers are smaller then the second and so forth.
