O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required