Excel's AutoFilter feature is easy to implement and use, but it can do more than first meets the eye. The trick is to be a bit creative. The tips in this article aren't related in any way; they all ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos. Editor’s Note: This article was originally published in July 2010 and the ...

One of the most popular tasks in Microsoft Excel is filtering dates by month, or another particular criterion. However, there are times when the Excel date filter grouping does not work as intended, ...

From sales figures to production projections, employee performance data to equipment logs, Microsoft Excel provides a flexible, powerful means of investigating the hidden information within your ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here’s how. Pivot tables in Microsoft Excel are a great way to organize and analyze ...

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...