How to Use ‘Advanced Filter’ to Select and View a Specific Set of Data (Excel 2010/2007)
This operation allows you to extract specific data for review. You can create a ‘set’ of specific criteria to use to ‘Filter’ the data. In this example we will pull out specific information from a list of employees. We will create criteria that will display employees that were employed before a specific date, make more than $40,000 and work in one of three departments. This will work the same in Excel 2010 and Excel 2007.