Dynamic data filtering and creating sub-tables using FILTER function in Excel

Using a simple and powerful Excel FILTER function to create a dynamic data filtering, displaying sub-tables base on the dropdown selection and conditions.