Home › Functions › Lookup & Reference › =CHOOSECOLS()
Lookup & Reference Excel 365 ◉ 7 views Dynamic Array

=CHOOSECOLS()

CHOOSECOLS function

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac
=CHOOSECOLS(array,col_num1,[col_num2],…)
Hover argument names in the table for details.
Output typeArray
Popularity50 / 100
VolatileNo
Dynamic ArrayYes
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =CHOOSECOLS() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download CHOOSECOLS.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
array Array Required The array containing the columns to be returned in the new array.
col_num1 Number Required The first column to be returned.
col_num2 Number Optional Additional columns to be returned.

▣ Examples