using A1 notation in array
Hey,
I am trying to achieve something that would seem reasonably simple but just doesn’t work.
I have 2 ranges e.g. A1:A3 and C6:C8 and I want to use these in an array.
So when I use ={A1:A3,C6:C8} i except to see an output of:
<content of cell A1><content of cell C6><content of cell A2><content of cell C7><content of cell A3><content of cell C8>
what i see instead is the incredible helpful error message of “the formula in this cell contains an error”
I tried both both the column and row seperator ( , ; ) but both lead to the same error message.
Any
Hey, I am trying to achieve something that would seem reasonably simple but just doesn’t work. I have 2 ranges e.g. A1:A3 and C6:C8 and I want to use these in an array. So when I use ={A1:A3,C6:C8} i except to see an output of:<content of cell A1><content of cell C6><content of cell A2><content of cell C7><content of cell A3><content of cell C8> what i see instead is the incredible helpful error message of “the formula in this cell contains an error” I tried both both the column and row seperator ( , ; ) but both lead to the same error message. Any Read More