In this chapter
Duplicate data is a common problem in Excel. Microsoft has provided new tools in Excel 2007 to make finding and eliminating duplicates easier.
Autofiltering has been in Excel for a decade, but it has received a makeover in Excel 2007. The autofilter drop-downs now allow you to multiselect values and offer new smart filters.
The Advanced Filter command continues to be available, still as complicated as ever. The hope is that with the excellent improvements to autofiltering and the addition of duplicate handling, you will never have to turn to Advanced Filter. In previous versions ...