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.
Description
How To Use in Sheets
ARRAYFORMULA(array_formula)
External Links
Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions Tutorial
earn how to use ARRAYFORMULA function in Google Sheets as well as arrays in Google Sheets. This tutorial will cover array syntax, ARRAYFORMULA, SORT & ARRAY_CONSTRAIN functions and other tips and tricks.
12Better Sheets Tutorials
12