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.
Microsoft added powerful new features to the Filter command in Excel 2007. ...