Excel supports two different ways to filter data that are in tabular format. Autofilter is a built-in capability driven via the user interface. As sophisticated as Autofilter has become in recent versions of Excel, no pre-defined setup can possibly cater to all the different questions that the consumer may want answered. These require a custom [...] Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2012/07/07/excel-advanced-filter/
Jul 07 2012, 03:51 PM
Daily Dose of Excel
Filed under: Excel12, User Interface, Filtering, Excel 14, Excel Basic, Excel Intermediate, Excel 2007, Excel 2010, advanced filter, remove advanced filter, filter advanced, custom filter, advanced data filter, data analysis, advance filtering, advanced sort & filter, advanced filter criteria