How to use the FILTER Function in Excel (multiple use cases)

Learn how to filter data on multiple criteria, filter rows missing values, filter out blank rows, and more using Excel's FILTER function. This tutorial explains how to use Excel's new FILTER function to create dynamic filters to slice data in seconds. We'll break down each argument, review how the function works behind the scenes, things to note, the advantages of using this function, multiple different use cases, and more. After watching this tutorial, you will never be filtering data manually again!

In this tutorial, we'll cover these use cases:
-How to filter data based on one criteria
-How to filter data based on multiple criteria
-How to return rows missing values
-How to remove blank rows by filtering them out

Excel's FILTER function allows you to filter data in Excel based on criteria. The criteria is based on one column, but you can add multiple criteria to filter the data on multiple columns using the AND logic. This function opens up a whole new world of opportunities when analyzing data within the worksheet.

📖RESOURCES

🤓SHOP EXCEL DICTIONARY

📩NEWSLETTER

📺SUBSCRIBE

🕰️TIMESTAMPS
'0:00 Intro
'0:26 FILTER Function Overview
'2:11 Filter on multiple criteria
'3:05 Return rows missing values
'3:47 Remove blank rows
'4:41 Wrap up
#excel #exceltips #tutorial

[claudiafreeman]

I find this function to be more cumbersome, having to type out the formula and have a value identified to specifically search for, than the dropdown feature. I use the dropdown so I can filter on multiple columns and for several purposes when working with large amounts of data. If I needed it for the example used, then I can see it being very useful. I also have the filter on Quick Access Toolbar so it’s easy to find and I love the “Contains” text filter when searching for items that may not import from a system as accommodating as others. But I love all your videos! Keep them coming 🙂

[m.w.]

This option for sure, I hate the sort & filter dropdown. These dynamics are great!

[andreausa]

Great ❤ if there is one column which includes numbers, is it possible to get the sum of all rows numbers ?

[andyhydes]

It's a great feature, but then you have to manually type in the Representative or month to filter the data. With the current filter function you don't need to do that.

[thegooplife]

I can't seem to use this in a table column.

[mohammedalhamad]

😉😉😉😉😉😉😉😉😉😉😉😉😉😉😉 اوووووووة انتي رائعه جداااااااا

[АнастасияТригубенко-бн]

How to use this function if I will add new data in the main table below?