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..How 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 a