SEQUENCE function in opposite order

[wigi]

Hello all,

The SEQUENCE function is new in Excel. It can be very useful, certainly when we use it as input in other functions. (MrExcel has a cheap e-book on the topic of the new dynamic array functions)

Now my question: SEQUENCE generates a sequence of numbers row by row, and on every row, column by column.
Does anyone know how to generate the series in the opposite direction: first all rows of the first column, then all rows of the second column, and so on.

Thanks a lot !

Wigi

 

[shaowu459]

I replaced {0,10} with a 3rd SEQUENCE function, since then I can make the number 10 dynamic too.
=SEQUENCE( 1, 2, 0, 10 ) and 10 becomes a cell reference.
In my application that number is based on other parameters.

there are many ways to achieve the same result.
If A1=10, =IF({1,0},0,A1) will return {0,10} too.

 

[wigi]

Thanks shaowu459