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..Synonyms for FILTERED: purified, pure, undiluted, refined, rendered, unadulterated, clarified, uncontaminated; Antonyms of FILTERED: mixed, diluted, contaminated