O'Reilly logo

Excel® 2013 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

Filtering enables you to quickly wade through waves of data and see only the records needed to answer an ad-hoc query.

Excel continues to improve the Filter (née AutoFilter) feature with hopes that you will never have to venture into the complicated Advanced Filter feature. When it’s combined with the Remove Duplicates command, you might never have to use the Advanced Filter.

The elusive Filter by Selection feature enables you to invoke filters even faster than before.

Duplicate data is a common problem in Excel. Beginning with Excel 2007, Microsoft provided tools to make finding and eliminating duplicates easier.

Filtering Records

Microsoft added powerful new features to the Filter command in Excel 2007. ...

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