Administration and Executive AssistantTier 820 minintermediate

CHOOSECOLS Column Order

Extract a specific column from a wide table, using the right index number.

What you will learn

• Use CHOOSECOLS to pull specific columns out of a range by index number
• Explain that CHOOSECOLS returns columns in the order their index numbers are given
• Recognise that a wrong index number still returns a real column, just not the intended one

Excel skills

CHOOSECOLS · Array Formulas

The task

Eight reps' quarterly sales are listed - Rep, Q1, Q2, Q3, Q4. Extract the first rep's Q4 figure into Summary!B3, using CHOOSECOLS to pull out the right column.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free