Constrains an array result to a specified size.
ARRAY_CONSTRAIN()
Description
How To Use in Sheets
ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
External Links
Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions Tutorial
Learn 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.
0Better Sheets Tutorials
No videos yet. Stay tuned!