Hi,
I have an array formula that ends off with {"1";"2";"3","4"}
I need a formula trick that can add cells or text to this column, so that when i evaluate it, it will become {"1";"2";"3","4","5","6","7"}
The latter numbers will be coming from cells or hard-coded values. I need both ways (which shouldn't make a difference anyways).
I've tried the choose({1;2},{array1},{array2}) method, but it's not working like i need it. it need to be robust to expand to any size i feed it.
(probably will need indirect in the beginning)
Hope i'm clear enough!
Thanks
I have an array formula that ends off with {"1";"2";"3","4"}
I need a formula trick that can add cells or text to this column, so that when i evaluate it, it will become {"1";"2";"3","4","5","6","7"}
The latter numbers will be coming from cells or hard-coded values. I need both ways (which shouldn't make a difference anyways).
I've tried the choose({1;2},{array1},{array2}) method, but it's not working like i need it. it need to be robust to expand to any size i feed it.
(probably will need indirect in the beginning)
Hope i'm clear enough!
Thanks