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..We carry 3D printing activated carbon, air filters, fume extractors, gloves, and more. Thank you for supporting our small business!