filter4dAlmost any type of element that can be displayed in the viewport can be switched on or off here on the Filter tab. The options are self-explanatory: A few elements (e.g., Fields) will beMethod 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..