Forum Discussion
jjbbss
Oct 29, 2024Copper Contributor
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...
- Oct 29, 2024
{} is for array constants, not formulae. Use =HSTACK( A1:A3, C6:C8 )
SergeiBaklan
Oct 29, 2024Diamond Contributor
{} is for array constants, not formulae. Use =HSTACK( A1:A3, C6:C8 )