The columns to return are provided as numbers in separate arguments.
Each number corresponds to the numeric index of a column in the source array.
The result from CHOOSECOLS is always a single array thatspillsonto the worksheet.
you’re free to also use an array generated with a formula.
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.
TAKE Function
The Excel TAKE function returns a subset of a given array.
The number of rows and columns to return is provided by separaterowsandcolumnsarguments.
Rows and columns can be extracted from the start or end of the given array.
The number of rows and columns to remove is provided by separaterowsandcolumnsarguments.
The numbers given for rows and columns represent the dimensions of the final array….
