Excel Pro Tricks: Dynamically Filter Data based on Month with FILTER function in Excel Formula

Learn how to dynamically filter data based on specific month of the year using simple to use functions in Excel formula.

In this tutorial, we learn how to filter or extract data dynamically based on month using FILTER function and MONTH function in Excel. With MONTH function, we are able to generate number of the month using the dates in the data that is used to filter the dates in Excel data.

As we are using array formula, the results are dynamic. And if we change the month from the list, the extracted data updates automatically instantly.

Lets Excel!

Access or Download Practice workbook for this Excel tutorial:

For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel YT channel.

Learn #Excel your way:
===================
--------------------------------------

Pick your favourite social page:

#excel #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #exceltable #exceldata #data #dataentry #dataentryjobs #dataentryspecialist #excelfilter #excelfilterfunction #filter #filterfunction

[Odawg]

Learning these new tricks of excel. Brain overload lol. How can this be done with the data on a separate sheet? I have a ton of data but wanted to know if and how that would work with the date on a separate sheet.

[captainmartine]

Waiting for next trick Excel, yuh are out of the box bro gud job👌

[pytcbws]

What the Title name song ? Please tell me I love it . ❤❤

[danieldanieldadada]

First time I feel in the club learning Excel

[MO-crnt]

Thanks for this tips. Pls which video edition app do you use for your videos?

[martak]

I am interested in how to calculate km by postcode. That is, home code, work code and home code. So that it automatically calculates

[elprofesor]

Podría usar tu material para crear shorts en español? Tienes algún curso al que pueda recurrir para llegar al nivel Max como tú?

[DileepSingh-dfuo]

not showing filter function in ms-2019 can u give alternative

[pritampant]

Before this process, how to make month filter and number in next cell

[sunnysun]

I created the drop down list, but when I clicked MAY, it does not connect to the right hand side number, such as 5 . How to connect both drop down lists together ??

[ASR_BIOTECH]

I want to asked, can i usk this function between 2 sheet which is enabled macro using form, on particular sheet1 have macro enable form data saved another sheet2 but I am pulling data from sheet 2 to sheet 1, but this function is not working plz help me

[thakursamveeth]

Hi Sir your shorts are amazing master peice in excel thanks a lot I want to know the background music name?

[narendram.c.]

Sir
Mere excel me filter formula nai dekharahi he ..
Ham keya kar sakte he ..sir 🙏

[captainmartine]

Please Sir upload the next Tricks excel Shorts I'm waiting sir here, after long time please upload next new shorts, what happened ??

[nadahkhi]

What if the data has different years? Would the results be correct?

[rrdyhkk]

Sir, kindly help. I need same thing with students record, if I type a name to search with a specific name I want this to all of the students with that name. Thanks

[wahabanjorin]

You guys classes are tough on me. I have being on this for 48hours now no solution. Because I am using Wps spreadsheet

[siddharthmhaskar]

Kindly help i am not able to convert the month from drop-down list to number

[designexperience]

please help me with a formula, it has been bothering for about 3days

[RishabhTiwari-sher]

Sir mere system pr filter ka formula show ni ho rha h