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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.