Master the FILTER Formula in Excel (Beginner to Pro)

Подписаться 522 тыс.

Просмотров 88 тыс.

50% 1

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

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 70

@KenjiExplains Месяц назад

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

@Reverse.Engineers 3 дня назад

Superb Kenji ! It's really Good

@shantanushinde585 4 дня назад

simply great

@EffigyOfAdam 10 дней назад

You are amazing. I hope you see this. You are helping me I knew nothing about Excel and now I have my first Data Strategist job!!!!

@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.

@GuruDanny Месяц назад

Great explanation - easy to follow - Thank you.

@RLTango Месяц назад

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

@ruslanazimov8616 Месяц назад

Nice to see you back here again

@debbielaubscher4983 Месяц назад

Absolutely brilliant trainer!

@insavin 25 дней назад

Thanks Kenji, really appreciated your tools

@camlex6310 Месяц назад

Such a great function!! and explanation!!

@markpodesta4605 Месяц назад

Thank you Kenji!

@Luciano_mp Месяц назад

Good examples, thank you.

@yousefabdelsamie5983 17 дней назад

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

@financnifitness2583 Месяц назад

Valuable lesson!

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

@christybrown2088 Месяц назад

Thanks Kenji

@lovestreaming Месяц назад

Very inspiring. Thank you very much 🙂

@KenjiExplains Месяц назад

thank you for watching!

@Bottob393 Месяц назад

Great video 👍🏾

@Fuhnance Месяц назад

Great video!

@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 😅

@yerocastrocontabilidad Месяц назад

awasome, thanks

@ZyadKhalid-hf2vu Месяц назад

You are Amazing! THanks!

@KenjiExplains Месяц назад

Happy to help!

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

@bankimdas9517 Месяц назад

Awesome video.. Thanks 🙏

@KenjiExplains Месяц назад

Glad you liked it!

@leenverkade 25 дней назад

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

@ntkp87 Месяц назад

Thanks!

@KenjiExplains Месяц назад

Thank you for your support! 🙏

@rickyboisseau9691 25 дней назад

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

@jtt2668 25 дней назад

Thanjq😮boss

@user-rr5dy9hk2k Месяц назад

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!

@athruncagallifan Месяц назад

Interesting!

@KenjiExplains Месяц назад

Glad you think so!

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

@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

@nizarimi Месяц назад

Done subscribe.

@MrPathak001 Месяц назад

are slicers also considered as filters?

@md.habiburrahman2125 Месяц назад

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

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

@shiva20021 13 дней назад

Is there alternative to CHOOSECOLS?? When using this function is a large set of data, and trying to get data from only few columns, counting cols no is difficult

@mauv 20 дней назад

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?

@MahbubLaskar-gv5bt Месяц назад

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

@xllearner 22 дня назад

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

@fei7954 13 дней назад

Yes, noramlise to Country A & B in that column, use filter to filter off using the same key word country A & B

@xllearner 13 дней назад

@@fei7954 Thank you for the explanation.

@scotthunter7140 Месяц назад

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

@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

@NahlaIshfaq 8 дней назад

assume you want to have multiple selections for example we want the records both country is france and India.how to do it using this formula

@Waheed1736 Месяц назад

Choosecols is not available in my excel

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

@RichardJones73 Месяц назад

Use tables

@steventaylor3411 Месяц назад

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 Месяц назад

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 Месяц назад

@@KenjiExplains valid point 🤔