Show only few columns using FILTER function in Excel 365

[@tanakornpromthep9025]

Thank you

[@analyticssuccess]

@@tanakornpromthep9025 Glad you liked it

[@adrianreboredamartinez1073]

I think is easer use CHOOSECOLS over FILTER: =CHOOSECOLS (FILTER(...),1,3), changing 1 and 3 by the index of columns you want to keep.

[@analyticssuccess]

I have another video where I have shown how to use CHOOSECOLS. It is always good to know alternatives, in case you don't have access to a particular function. For instance, CHOOSECOLS in not available in Excel 2021. Folks using EXCEL 2021 will need to rely on FILTER. But very happy to see that you have a deep understanding of the newer functions as well. Best wishes.

[@adrianreboredamartinez1073]

@@analyticssuccess You're right. I didn't know tha CHOOSECOLS is only available in Office 365.

[@rowedumm]

HI, what if I wanted to just see Column A and Column D without specifying the word "Phones", Is there a filter formula for that?

[@analyticssuccess]

Thanks for your question. You can use two options.
The first option is using the FILTER function. The formula that you can write is =FILTER(A1:D65,{1,0,0,1})
The second option is to use the CHOOSECOLS function. The formula that you would write is =CHOOSECOLS(A1:D65,1,4)
If you want to learn how to use the CHOOSECOLS function, you can see this video th-cam.com/video/nl96gs-o8I4/w-d-xo.html

[@adrianreboredamartinez1073]

Use filter and CHOOSECOLS over it: =CHOOSECOLS (FILTER(...),1,4)