4 ms·
I might be missing something obvious, but wouldn't B2 be ambiguous, as it could refer to either B2:B11 or say B2:H2?
by wolpoli 4y ago
I might be missing something obvious, but wouldn't B2 be ambiguous, as it could refer to either B2:B11 or say B2:H2?
- amelius 4y agoThe obvious thing you are missing is that you'd have to define it in some other way, e.g. by selecting the cell and clicking "Define array" or something along these lines.
- Closi 4y agoYou either make a table and refer to a column, or define the array in the cell and then refer to it with a hash (i.e. B2# refers to the array of cells stored/referenced in B2).