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

How to use And and Or operators with Excel’s Advanced Filter Your email has been sent Editor’s Note: This article was originally published in July 2010 and the video tutorial for this article ...

Your spreadsheet contains a huge table of data you want to slice and dice on the fly? You need the AutoFilter feature, which works like a database query builder—or for the non-bitheads, iTunes Smart ...

You don’t need more effort; you need better formulas.

The Excel AutoFilter feature allows you to narrow your data based on certain criteria and extract records that match those criteria. To turn on a filter, select the cells with data that you want to ...

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

Excel spreadsheet databases work because users can filter the data inside these workbooks. Filters are conditions you specify in databases and spreadsheets to extract only the precise, requested ...

Pivot tables in Microsoft Excel are a great way to organize and analyze data, and the more you know about the feature, the more you’ll get out of it. For instance, filtering a pivot table is a great ...