The rows to return are provided as numbers in separate arguments.
Each number corresponds to the numeric index of a row in the source array.
The result from CHOOSEROWS is always a single array thatspillsonto the worksheet.
The first argument in the CHOOSEROWS function isarray.Arraycan be a range, or an array from another formula.
Additional arguments are in the form row_num1, row_num2, row_num3, etc.
you might also use an array created with a formula.
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.
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….
