21. Removing Duplicates and Filtering

Autofiltering has been in Excel for a decade, but it received a makeover in Excel 2007. The autofilter drop-downs allow you to multiselect values and offer smart filters. The elusive Filter by Selection feature allows you to invoke filters even faster than before.

The Advanced Filter command continues to be available and is 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 legacy versions of Excel, I almost always had to resort to using Advanced Filter to find a list of unique values. However, the Remove Duplicates command allows you to find unique values with a couple mouse ...

Get Microsoft Excel 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.