Please note javascript is required for full website functionality.


A to Z of Excel Functions: The CHOOSECOLS Function

21 March 2022

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the CHOOSECOLS function.

The CHOOSECOLS function

The CHOOSECOLS function returns the specified columns from an array.  It has the following syntax:  

CHOOSECOLS(array, column number 1, [column number 2, …])

The CHOOSECOLS function has the following arguments:

  • array: this is required and represents the selected array
  • column number 1: this is also required and denotes the column number of the first column to be returned
  • column number 2: this and subsequent arguments are optional.  This / these represent(s) the second and subsequent column numbers to be returned.

It should be noted that Excel will return an #VALUE! error if the absolute value of any of the column number arguments is zero or exceeds the number of columns in the array.

Please see my examples below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.

A full page of the function articles can be found here.