CONTINUE returns a specified cell from an array formula result.
CONTINUE(source_cell, row, column)
source_cell- The cell containing the array formula for which the cell containing
CONTINUErepresents a part of the result.
row- The row relative to the result of the formula in
column- The column relative to the result of the formula in
CONTINUEfunction is added automatically when an array formula is used.
CONTINUEcan be used manually in cases where an array formula is wrapped in
CONTINUEmanually with absolute cell references allows the values returned by
CONTINUEto be sorted with Google Sheets sort functionality.
NOEXPAND: Prevents the automatic expansion of array formula output as the output size grows.
EXPAND: Forces the automatic expansion of array formula output as the output size grows.
ARRAYFORMULA: Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.
Displays only two rows of data, using
Then displays five rows of data by changing the
Displaying Rows from 2 to 5. The result shows the difference between using
NOEXPAND and without using
Displays the usage of
NOEXPAND applies to the result of
CONTINUE can be used to reference the specific cell and return the value.