O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel 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

Chapter 13. Removing Duplicates and Filtering

In this chapter

Using Remove Duplicates to Find Unique Values 272

Filtering Records 275

Using the Advanced Filter Command 284

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

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