I. Intro
The ARRAY_CONSTRAIN function can be used to return a data set with a specified number of rows and columns.
II. About the function
- Formula: =ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
- Arguments:
- input_range: The data range to constrain.
- num_rows: Specifies the number of rows the data set should contain.
- num_cols: Specifies the number of columns the data set should contain.
- Example: =ARRAY_CONSTRAIN(A1:E6, 3, 3) extracts the data from the first 3 rows and first 3 columns of the A1:E6 range.
250px|700px|reset
III. Steps
Use the function
- Open the spreadsheet, select a cell, and enter the formula =ARRAY_CONSTRAIN(input_range, num_rows, num_cols).
- Press Enter to get the result.
250px|700px|reset
Delete the function
Select the cell with the function and press Delete.
IV. Use cases
Quickly extract information
With this function, you can quickly extract the information you need from a large data set.
In the following example, the A2:D7 range consists of sales data from January to June. You can quickly extract the sales data for the first quarter (January to March) through the formula =ARRAY_CONSTRAIN(A2:D7,3,4). The 3 in the formula represents the first 3 rows, and the 4 represents the first 4 columns, which contains all the data for the first quarter.
250px|700px|reset