When using this line in a cell =COLUMN(A1:D1), we got 1 to 4 as 1d array
How can I get the 1d array reversed?
I tried to reverse the reference D1 to A1 but I got the same.
When using this line in a cell =COLUMN(A1:D1), we got 1 to 4 as 1d array
How can I get the 1d array reversed?
I tried to reverse the reference D1 to A1 but I got the same.