The size of the array returned is determined by separaterowsandcolumnsarguments.
Negative numbers take values from the end or bottom of the array.
Positive numbers take values from thestartof the array; negative numbers take values from theendof the array.
Bothrowsandcolumnsdefault tototalrows and columns.
If no value is supplied, TAKE will returnallrows/columns in the result.
The formula in F8 is:
The TAKE function returns the first 2 columns of the first 4 rows.
Notice that if a number forrowsorcolumnsis not provided, TAKE returnsallrows or columns.
Also notice that positive numbers forrowsorcolumnstake values from thestartof thearray.
The number of rows and columns to remove is provided by separaterowsandcolumnsarguments.
The rows to return are provided as numbers in separate arguments.
Each number corresponds to the numeric index of a row in the given array.
CHOOSECOLS Function
The Excel CHOOSECOLS function returns specific columns from an array or range.
The columns to return are provided as numbers in separate arguments.
Each number corresponds to the numeric index of a column in the given array.
The numbers given for rows and columns represent the dimensions of the final array….
