filter4dFiltered is a learning tech pany that helps organisations get the best return on their L&D spend. That means using data to decide on the most important skills for an organisation.Method 2 – Use the Excel FILTER Function to Extract Data Based on a Data Validation Drop Down List. If you are working in Excel 2019 and later versions or in Microsoft 365, you can filter data using the FILTER function..