CHOOSECOLS

CHOOSECOLS(array, col_num1 [,col_num2] [..])

Returns the array with just a specific number of columns.

array	The array(s) to append.
col_num1	The column number to be returned.
col_num2	(Optional) The column number to be returned.

REMARKS

* This function was added in Microsoft 365.
* This function can create a Dynamic Array Formula.
* If "col_num" > 0 then columns are counted from the left.
* If "col_num" < 0 then columns are counted from the right.
* If "col_num" > the number of rows in the array, then #VALUE! is returned.
* If "col_num" = 0, then #VALUE! is returned.
* You can use the CHOOSEROWS function to return the array with just a specific number of rows.
* You can use the DROP function to return the array without certain rows or columns.
* You can use the EXPAND function to return the array expanded or padded to specific dimensions.
* You can use the TAKE function to return the intersection of specific rows and columns in an array.
* This function was first released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D	E
1	=CHOOSECOLS(C1:E3,1) = {1 ; 4 ; 7}		1	2	3
2	=CHOOSECOLS(C1:E3,-1) = {3 ; 6 ; 9}		4	5	6
3	=CHOOSECOLS(C1:E3,2) = {2 ; 5 ; 8}		7	8	9
4	=CHOOSECOLS(C1:E3,-2) = {2 ; 5 ; 8}
5	=CHOOSECOLS(C1:E3,3) = {3 ; 6 ; 9}
6	=CHOOSECOLS(C1:E3,1,3) = {1,3 ; 4,6 ; 7,9}
7	=CHOOSECOLS(C1:E3,4) = #VALUE!
8	=CHOOSECOLS(C1:E3,1,0) = #VALUE!

1 - What is the first column from the cell range "C1:E3".
2 - What is the last column from the cell range "C1:E3". A negative number is used to count from the right.
3 - What is the second column from the cell range "C1:E3".
4 - What is the second to last column from the cell range "C1:E3". A negative number is used to count from the right.
5 - What is the third column from the cell range "C1:E3".
6 - What are the first and third columns from the cell range "C1:E3".
7 - What is the fourth column from the cell range "C1:E3". There are not four columns.
8 - What happens when one of the column numbers is zero.