👉 Take our Excel course: www.careerprinciples.com/courses/excel-for-business-finance

Nice to see you back here again

Thanks Kenji, really appreciated your tools

Great explanation - easy to follow - Thank you.

The bonus is what I needed. Thank you very much!

Subscribed! Thank you for sharing such useful information and techniques.

Thank you very much Kenji. This is some great stuff being shared here.

Thank you so much, your videos are crystal clear and informative and very nice edits.

Absolutely brilliant trainer!

Good examples, thank you.

Such a great function!! and explanation!!

Thank you Kenji!

thank you so much for sharing your knowledge..i'm amazed!btw,i'm just confused why sometimes there are 2 or 3 close parenthesis?but most of the times it's just 1 close parenthesis at the end of the formula. please enlighten me...thanks in advance!

Great video, Kenji! I've really appreciated your explanation for the filter function on a not so long video!

@KenjiExplains

Ай бұрын

Thank your for the lovely comment!

Is it possible to filter for two countries in the same column? I could not seem to get it to work.

Valuable lesson!

Awesome stuff! Im trying to get the choosecols to work on the last example. Not getting it quite right.

Love the videos as always Kenji! Some other approaches I wanted to share: for 3 you could also use the drop function to remove the first column and for 4 you could use averageifs or sumifs although that would no longer be in a filter video 😅

Very inspiring. Thank you very much 🙂

@KenjiExplains

Ай бұрын

thank you for watching!

Great video 👍🏾

Great video!

Thanks Kenji

Thank you for such a detailed and clear tutorial. I have my Master data on a secondary worksheet and am searching on my main worksheet. my question is, am I able to delete from the results or connect a button in some way to Identify where the singular result is coming from on my secondary sheet to delete that entire row ???

Awesome video.. Thanks 🙏

@KenjiExplains

Ай бұрын

Glad you liked it!

You are Amazing! THanks!

@KenjiExplains

Ай бұрын

Happy to help!

awasome, thanks

Could you please provide guidance on how to edit data within Excel filtered results? I'm interested in learning methods to manipulate and update data while working with filtered views in Excel. Any assistance or instructions you can offer would be greatly appreciated. Thank you!

Thanks!

@KenjiExplains

18 күн бұрын

Thank you for your support! 🙏

Hi Kenji, Do you know how to do a filter similar to the choosecol, but that it will (group or ungroup/hide or unhide) the columns you don't want to see?

are slicers also considered as filters?

Interesting!

@KenjiExplains

Ай бұрын

Glad you think so!

I dont have some features/functions in my excel. eg.choosecols, vstack. I have updated my excel 2021 to the latest version yet dont have these features. Are they exclusive to a different excel version?

Excellent video as always Kenji! I still have a tendency to format as table and just do pivotting, so this was great for me :) As someone working in finance though, I have to admit, it sticks out when your number formatting in the the input is good, but the output is bad :D Devil is in the details right?

@KenjiExplains

Ай бұрын

Haha that's a great point! Thank you for sharing your thoughts :)

Thanjq😮boss

I didn’t quite follow the 2nd one when you say you put a “+” sign for or. It is only working for the industry but United States 🇺🇸 remains static

Very good, but you could have used wildcards instead of SEARCH, and selected each column followed by a comma instead of CHOOSECOLS.

@KenjiExplains

Ай бұрын

Thanks! Have you tried to wildcard? It doesn't work in this situation unfortunately

How can I find a specific word in column then filter it, please

Done subscribe.

Sir, i am from Bangladeshi, i have fans for you. I need a complete data analytics vedio step by step, thanks

Choosecols is not available in my excel

Love your videos, great to learn from. You just go too fast. 😂

for the last one does the search with the wildcard * work?

@excelgazialimuhiddinhacibekir

Ай бұрын

I was gonna try exactly that. Something like :: *=FILTER( **_data.range_** , **_company.name.range_** = "*family*" , "No match found!")*

@excelgazialimuhiddinhacibekir

Ай бұрын

I tried it. NOPE, IT DOESN'T WORK! 😞

Why not convert range to table and reference table columns? It is dynamic and adjusts as you add or remove columns. I see so many Excel tutorial videos where the array is selected and it drives me crazy 🤪

@KenjiExplains

28 күн бұрын

Its because most people aren't familiar with tables so if you're already teaching them something new (the fitler function) then teaching them 2 new things at once can be even more confusing

@steventaylor3411

28 күн бұрын

@@KenjiExplains valid point 🤔

@michaelomosebi6374

27 күн бұрын

I still think it's better if formatted as table too. On the long run the learners will appreciate more

Use tables

Like always😂

@KenjiExplains

Ай бұрын

Haha thank you for watching always :)

@UtkarshKumar-mp2ls

Ай бұрын

@KenjiExplains "Your uploading time and my KZread scrolling always seem to match somehow."

Why does the thumbnail say to stop using the filter function when this entire video is about using the filter function?

@KenjiExplains

9 күн бұрын

*Filter tool not filter function. I think you misread that