CHOOSECOLS function

Category: Lookup and reference
Introduced: Excel 2024

Summary

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.

Example

=CHOOSECOLS(A2:E7,1,3,5,1)
=CHOOSECOLS(A2:D7,3,4)
=CHOOSECOLS(A2:D7,-1,-2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff

Back to Functions