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..Table-top filters can remove contaminants from tap water – but are they really necessary, and could they cause unintentional harm? If she can help it, Shima Chin-See