Choose Certain Columns as Output in Excel | CHOOSECOLS & FILTER Combo

if you use the filter function in Excel you're probably going to need this function as well choose calls with it you get to select your data and then Define The Columns that you need and you do that based on an index number let's say I want to keep column 1 and column 3 only because I just want the names and salaries back I'll put a one and a three press enter and I get names and salaries back what if I didn't want everything returned but only the salaries that are above a hundred thousand well I could combine this with a filter function so for my range here I'm gonna get it filtered before I choose what to return this is my array what I want included are salaries that are greater than a hundred thousand now close the bracket for the filter function and press enter and I get to choose what I want returned with choose calls that's it let me know what you think

Channel: Leila Gharani

Views: 84,841

Keywords: XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, XelPlus, Microsoft 365, Excel 365, choosecols, filter, filter function, excel filter function, ms excel tutorial, excel dynamic arrays

Id: eaO7Nyd_4JM

Length: 0min 57sec (57 seconds)

Published: Sun Jun 25 2023