Hello
I want to create an array with dynamic data (that is not a simple range), what is the best way to do that?
E.g. how can I create an array with A1:A5,A10:A15 ?
From my reading, it seems there are few ways, like creating a SEQUENCE first etc but what is the optimal and most flexible way?
Thanks!
I want to create an array with dynamic data (that is not a simple range), what is the best way to do that?
E.g. how can I create an array with A1:A5,A10:A15 ?
From my reading, it seems there are few ways, like creating a SEQUENCE first etc but what is the optimal and most flexible way?
Thanks!