Forum Discussion

jjbbss's avatar
jjbbss
Copper Contributor
Oct 29, 2024
Solved

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...
  • SergeiBaklan's avatar
    Oct 29, 2024

    jjbbss 

    {} is for array constants, not formulae. Use =HSTACK( A1:A3, C6:C8 )