How to use the CHOOSECOLS function in Excel?

If you want to select only a few specific columns, then you can use the CHOOSECOLS function.

This provides you flexibility to choose columns like no other functions.

This simple function is powerful in itself, but can be extremely potent when used with other functions like FILTER.

🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:21 - Selecting the rows from left of the array
00:41 - Selecting the rows from the right of the array
01:12 - Using CHOOSECOLS with Filter to show only the necessary columns

▶️ Other videos that may interest you
How to use the CHOOSEROWS function in Excel?

✅ Subscribe to our Channel to level up your Excel skills faster

⬇️ Download the file used in the video

💻 Courses offered by us

Learn more about our Excel Masterclass course

Explore all courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)

🗂️ Access all our templates and E-Books

🤝 Connect with us

#analyticssuccess

[silvestrecamposano]

Thank you very much for the new technique that I can use in my work!....

[bestoptimate]

Hi, I have viewed a couple of your videos, those are very nicely done and are informative as well. I have subscribed to your channel and wish to see more informative, well-presented videos on Excel. I think you must share your videos on social media as well, and write some articles on Medium, Reddit Spaces, and Quora as well. Just don't stop, keep up the hard work. You'll reach where you want to....