Google Spreadsheets function to copy array
Is there an array function to copy an array? I use the workaround
=TRANSPOSE(TRANSPOSE(A1:A30)) currently.
An example of when this is useful: you have a worksheet of raw data, and
another worksheet with formulas applied to those values.
Doing it this way means that if a row is inserted in the first
spreadsheet, it will be inserted in the second.
No comments:
Post a Comment