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