Master the FILTER Formula in Excel (Beginner to Pro)

Рет қаралды 73,168

Күн бұрын

Master the FILTER function in Excel with 5 simple steps.
👉 Take our Excel course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
Learn how to master the FILTER formula in Excel. When used correctly, the filter function is one of the most powerful functions in excel. So let me show you how to use it using 4 examples from easy to hard, plus one bonus example at the end you might find surprising! First we'll go over a simple filter and compare it with the filter too. Then, we'll filter with more than one criteria with AND or OR conditions. Thirdly, we'll use the VSTACK and CHOOSECOLS formulas to add dynamic headers. Forth, we'll use an advanced filter to find the average if a certain condition is true. Finally, we'll create an approximate search with the ISBLANK, SEARCH, and FILTER functions.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Simple FILTER Formula
2:02 - FILTER with Multiple Conditions
4:14 - FILTER Headers
6:34 - Multiple Formulas
8:04 - Approximate FILTER

Пікірлер: 63

@KenjiExplains Ай бұрын

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

@ruslanazimov8616 Ай бұрын

Nice to see you back here again

@insavin 11 күн бұрын

Thanks Kenji, really appreciated your tools

@GuruDanny 26 күн бұрын

Great explanation - easy to follow - Thank you.

@RLTango Ай бұрын

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

@yousefabdelsamie5983 3 күн бұрын

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

@gilbertkyeadee5856 Ай бұрын

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

@azwarmzafar Ай бұрын

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

@debbielaubscher4983 29 күн бұрын

Absolutely brilliant trainer!

@Luciano_mp Ай бұрын

Good examples, thank you.

@camlex6310 27 күн бұрын

Such a great function!! and explanation!!

@markpodesta4605 Ай бұрын

Thank you Kenji!

@carolinaforbes5020 Ай бұрын

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!

@StefanoTerzolo Ай бұрын

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!

@xllearner 8 күн бұрын

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

@leenverkade 11 күн бұрын

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

@financnifitness2583 20 күн бұрын

Valuable lesson!

@basketballer852 Ай бұрын

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 😅

@lovestreaming Ай бұрын

Very inspiring. Thank you very much 🙂

@KenjiExplains Ай бұрын

thank you for watching!

@Bottob393 Ай бұрын

Great video 👍🏾

@Fuhnance Ай бұрын

Great video!

@christybrown2088 Ай бұрын

Thanks Kenji

@rickyboisseau9691 11 күн бұрын

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 ???

@bankimdas9517 Ай бұрын

Awesome video.. Thanks 🙏

@KenjiExplains Ай бұрын

Glad you liked it!

@ZyadKhalid-hf2vu Ай бұрын

You are Amazing! THanks!

@KenjiExplains Ай бұрын

Happy to help!

@yerocastrocontabilidad Ай бұрын

awasome, thanks

@user-rr5dy9hk2k 16 күн бұрын

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!

@ntkp87 25 күн бұрын

Thanks!

@KenjiExplains 18 күн бұрын

Thank you for your support! 🙏

@DanielaAguilera-ip3xv Ай бұрын

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?

@MrPathak001 Ай бұрын

are slicers also considered as filters?

@athruncagallifan Ай бұрын

Interesting!

@KenjiExplains Ай бұрын

Glad you think so!

@mauv 6 күн бұрын

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?

@kemad86x Ай бұрын

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 :)

@jtt2668 11 күн бұрын

Thanjq😮boss

@arindambhattacharya7848 Ай бұрын

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

@abzino Ай бұрын

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

@MahbubLaskar-gv5bt 26 күн бұрын

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

@nizarimi 17 күн бұрын

Done subscribe.

@md.habiburrahman2125 Ай бұрын

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

@Waheed1736 Ай бұрын

Choosecols is not available in my excel

@scotthunter7140 26 күн бұрын

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

@willzinner8813 Ай бұрын

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! 😞

@steventaylor3411 28 күн бұрын

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