Answer the question
In order to leave comments, you need to log in
How to display an array of data in Google spreadsheets if the address of this array is specified in a cell?
Starting from cell A2, you need to display an array of data, the address of which is recorded in cell A1
For example, cell A1 contains the address of the array: AR$2:$AV
If you specify the formula ={A1} in cell A2, then simply the record AR$2:$AV is displayed
Tried enclosing the address in quotes does not help.
How to output an array?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question