filter4dHow GSK used Content Intellence to get the best return on its L&D spend. Martin Peart, Onboarding & Training Director at GSK, explains how he worked with Filtered to generate aMethod 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..