Download Excel File: https://excelisfun.net/files/EMT1795-1797.xlsx
Buy excelisfun new book at Mr Excel Web Site: https://excel.bookstore.ipgbook.com/microsoft-365-excel–the-only-app-that-matters-products-9781615470709.php
Buy excelisfun new book at Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Learn how to filter a data set by month using the Filter feature and the FILTER function. See how to create dynamic Data Valication also..
Topics:
1. (00:00) Introduction
2. (00:17) Filter Feature for a data set with just one year of data
3. (01:20) Filter Feature for a data set with multiple years in in data set
4. (02:00) Create Dynamic Data Valication Dropdown List for Year and Month See the functions: SORT, TEXT, UNIQUE
5. (05:16) Create Filtering Formula using the functions: FILTER and TEXT
6. (06:07) Add new records to table and test if solution is dynamic
7. (07:07) Summary,
8. (07:26) Closing, Video Links