Use Excel's FILTER Function Like Never Before

In this video, we will learn how to use advanced Excel filtering with the Filter function in Excel. Discover cool tricks like filtering by multiple criteria, dynamic filtering, and tricks like filtering by a list of values and conducting wildcard searches. Improve your data analysis skills and become an Excel pro!
#filterfunction #excelfunction #exceltricks

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[jimfitch]

Great tutorial. I use FILTER function extensively. It took me a while to figure out these hacks. Your tutorial provides fabulous explanations.

[Rice]

In choosecol func you may use list style of column numbers: {1, 2, 3}.

[richardhay]

Use CHOOSECOLS and wrap it arround the horizontal array of headers and select the same column numbers as in the CHOOSECOLS wrap around FILTER to line up headers with the chosen FILTER columns.

[romulusmilea]

The formula to copy the header of raw data table is =Data[#Headers].

[emilmubarakshin]

Excellent tips and tricks. These are amazing for somebody who wants to transition from Excel to database thinking.

[sureshsagaram]

Chandeep you are superb in terms of content and clarity u are showing in your videos..Hats off

[joffrimpong]

Thanks for the video, but what it you want to choose a range ?

[donniemcgee]

Fantastic tutorial. I can think of many uses for it. Thank you very much.

[gandhisunil]

Hello Chandeep,
Amazing examples of filter, these can be further automated using developer text box to get the most out of these...
I too wished i had these before 🤗🤗

[ddp]

This is well created. I going to use it.

[igreen]

Thank you. Really helpful. Can you kindly assist with the following?

I have a table of transactions by customer, payment date, payment amount.
I want to extract the customer name, the last payment date and last payment amount. Ignore all other transactions.

[abhisheknandiable]

Amazing Chandeep! Hats off to your knowledge, attitude and the ease with which you explain the concepts. One question for you. How do I generate the column name dynamically? User selects one of the columns from 5 options (cols) and based on that selection the filter function selects that column dynamically

[hemalshahorigamilove]

Nice trick with countif..👍
Do you have choosecol video?

[EmuMan]

Can you do approx search for multiple inputs? ie organizations that contain both b and c or even a longer list?

[teoxengineer]

I wanna choose not all columns, two of them ore mixed ones. What will we do?

[topherl]

I enjoy your videos. What approach would you use with Filter to group by columns and sum the results?

[vijetasaralaya]

It takes curly brackets automatically when I use filter formula on excel file....I saved file and changed the data...the formula doesn't work....any suggestions please

[sujit]

Hi Goodly, i am not able to enroll in your course through card please make any other way to buy course

[emilmubarakshin]

Just tried doing this with text column and the formula wouldn't work - turns out Excel does not like dashes (minuses) (and I would suspect "+/*" either in text values). I took out dashes and it did work. Probably could have put quotations around the text to but went the easy way about it.

[Scoofnie]

the =filter function doesn't even work on my app, I don't understand why the online version of excel doesn't work the same as the downloaded app version.