filter4d4 Revit-Specific Topics 🏡; 4.5 The FilteredElementCollector. One of the most powerful tools in Revit API fetches elements - fast!Method 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..