ARRAY_CONSTRAIN
Truncates a range to at most the given rows and columns.
- Excel: No equivalent
- Google Sheets: Not checked yet
- Returns: Array
Examples
=ARRAY_CONSTRAIN(A1:A5, 2, 1) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
Result 10
Syntax
ARRAY_CONSTRAIN(range, rows, columns)range- range required
rows- number required
columns- number required
Related
ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array. CHOOSEROWSReturns the specified rows from an array.