Constrains an array result to a specified size.

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!