Excel like a finance pro.
← The libraryPractice · 3 questions →
Dynamic array function
CHOOSECOLS
Returns the chosen columns from an array, in the order you list them.
OccasionalDifficulty 1400 · AdvancedUsage rank #110 of 520
When to use it
Returns the columns you name from an array, in the order you name them. Negative numbers count from the right.
The shape of it
- Syntax
=CHOOSECOLS(array, col_num1, [col_num2], ...)
Worked examples
Pick and reorder
=CHOOSECOLS(A2:C6,3,1) → Region, Product
Two columns, reordered.
Last column
=CHOOSECOLS(A2:C6,-1) → Region column
The last column.
Every other column
=CHOOSECOLS(A2:F6,SEQUENCE(3,1,2,2)) → columns 2, 4, 6
Every other column from the second.
Worth knowing
- Reorder a FILTER result without helper columns.
- Combine with XMATCH on headers to pick columns by name.
- Pair with CHOOSEROWS for a rectangle.
Where it goes wrong
- #VALUE! when a column number is 0 or beyond the array.
- Requires Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.