filter4dMethod 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..Don't waste your employees' time with irrelevant content. Filtered uses a mix of artificial and human intellence to curate the content you need.