Excel functions / Dynamic arrays

CHOOSECOLS function

Returns the columns you name from an array, in the order you name them.

Syntax

=CHOOSECOLS(array, col_num1, [col_num2], …)

Arguments

When to use it

CHOOSECOLS returns the columns you list, by number, in the order you list them. It reorders a table or keeps only the columns a report needs, without copying anything.

Examples

  1. Rep and sales only

    ABCDEF
    1RegionRepSalesRepSales
    2NorthAna1200Ana1200
    3SouthBen800Ben800
    4NorthChloe900
    5WestAna400
    6NorthAna300

    In E1: =CHOOSECOLS(A1:C3, 2, 3) → Rep, Sales; Ana, 1200; Ben, 800

    Try this example

  2. Columns in a new order

    ABCDEF
    1RegionRepSalesSalesRegion
    2NorthAna12001200North
    3SouthBen800
    4NorthChloe900
    5WestAna400
    6NorthAna300

    In E1: =CHOOSECOLS(A1:C2, 3, 1) → Sales, Region; 1200, North

    Try this example

Common mistakes

CHOOSECOLS in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try CHOOSECOLS in the playground

Practise it

Related functions