How to us the TAKE and CHOOSECOLS functions in Excel
Returns a specified number of contiguous rows or columns from the start or end of an array.
Syntax
=TAKE(array, rows,[columns])
The TAKE function syntax has the following arguments:
array The array from which to take rows or columns.
rows The number of rows to take. A negative value takes from the end of the array.
columns The number of columns to take. A negative value takes from the end of the array.
While the CHOOSECOLS
Returns the specified columns from an array.
Syntax
=CHOOSECOLS(array,col_num1,[col_num2],…)
The CHOOSECOLS function syntax has the following arguments:
array The array containing the columns to be returned in the new array. Required.
col_num1 The first column to be returned. Required.
col_num2 Additional columns to be returned. Optional.
Errors
Excel returns a #VALUE error if the absolute value of any of the col_num arguments is zero or exceeds the number of columns in the array.