Home / Formula Types / Array / Choosecols

Formula generator for CHOOSECOLS function

The CHOOSECOLS function creates a new array by selecting specific columns from an existing range. It takes an array as the input and allows you to specify the column numbers you want to include in the new array. The resulting array will only contain the selected columns, preserving the original row order.

Formula generator

Spreadsheet AI is the #1 AI for generating and comprehending Excel and Google Sheets formulas. With its advanced capabilities, it goes beyond the basics by providing support for VBA and custom tasks. Streamline your spreadsheet with Spreadshee AI

Product Demo

How to generate an CHOOSECOLS formula using AI.

To obtain information on the ARRAY_CONSTRAIN formula, you could ask the AI chatbot the following question: “To get the CHOOSECOLS formula, you could ask the AI chatbot something like: "Is there a formula in Excel that allows me to choose specific columns from a dataset? I want to perform calculations only on those columns."

CHOOSECOLS formula syntax

The CHOOSECOLS syntax in Excel is used to select specific columns from a range of cells. It takes two arguments: the range of cells and a list of column numbers to choose. The syntax is as follows: =CHOOSECOLS(range, col1, col2, col3, ...) - "range" is the range of cells from which you want to select columns. - "col1", "col2", "col3", etc. are the column numbers you want to choose. For example, if you have a range of cells A1:D5 and you want to select columns 1, 3, and 4, you would use the formula: =CHOOSECOLS(A1:D5, 1, 3, 4) This will return a new range of cells with columns 1, 3, and 4 from the original range.

Use Cases & Examples

In these use cases, we use the CHOOSECOLS formula to select and return specific columns from a range. This formula allows us to specify the columns we want to include in the result, and it ignores the rest of the columns. It is particularly useful when we only need certain columns from a larger dataset.

Selecting Specific Columns from a Range


This use case demonstrates how to create a new array by selecting specific columns from an existing range. The CHOOSECOLS function allows you to specify the columns you want to include in the new array.


CHOOSECOLS(array, col_num1, [col_num2])

Filtering Data Based on Column Values


In this use case, we use the CHOOSECOLS function to filter data based on specific column values. By selecting only the desired columns, we can easily analyze and manipulate the data further.


CHOOSECOLS(array, col_num1, [col_num2])

Rearranging Columns in a Dataset


This use case showcases how the CHOOSECOLS function can be used to rearrange columns in a dataset. By specifying the desired column order, we can easily create a new array with the columns in the desired sequence.


CHOOSECOLS(array, col_num1, [col_num2])

AI tips

Enhance Your Excel Efficiency with AI Tips: Discover our innovative Excel add-in feature, ‘AI Tips.’ Streamline your workflow and boost productivity as AI-powered suggestions offer real-time insights for optimal spreadsheet organization, data analysis, and visualization. Elevate your Excel experience with intelligent recommendations tailored to your unique needs, helping you work smarter and achieve more.

Provide Clear Context

When describing your requirements to the AI, provide clear and concise context about the data you have, the specific task you want to accomplish, and any relevant constraints or conditions. This helps the AI understand the problem accurately.

Include Key Details

Include important details such as column names, data ranges, and specific criteria that need to be considered in the formula. The more precise and specific you are, the better the AI can generate an appropriate formula.

Use Examples

If possible, provide examples or sample data to illustrate the desired outcome. This can help the AI better understand the pattern or logic you are looking for in the formula.

Mention Desired Functionality

Clearly articulate the functionality you want the formula to achieve. Specify if you are looking for lookups, calculations, aggregations, or any other specific operations.