Рет қаралды 86,355
Join 300,000+ professionals in our courses: www.xelplus.co...
Sometimes you might want to choose only certain columns from your filtered dataset. For example you could apply a FILTER function on your entire data but only have selected columns from this dataset in the output. With a combination of Microsoft's new CHOOSECOLS function together with FILTER you can do just that.
Requires Microsoft 365. The CHOOSECOLS function will not be available in Excel 2021 and earlier versions.
🌍 My Online Excel Courses ► www.xelplus.co...
🎬 LINK to more KZfaq Shorts videos: • Shorts (Tips, Tricks &...
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
More resources on my Amazon page: www.amazon.com...
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel