How to Filter a Filtered Table in Excel - dummies

How to Filter a Filtered Table in Excel

By Stephen L. Nelson, E. C. Nelson

You can filter a filtered table in Excel. What this often means is that if you want to build a highly filtered table, you will find your work easiest if you just apply several sets of filters.

If you want to filter the grocery list to show only the most expensive items that you purchase at Sams Grocery, for example, you might first filter the table to show items from Sams Grocery only. Then, working with this filtered table, you would further filter the table to show the most expensive items or only those items with the price exceeding some specified amount.

The idea of filtering a filtered table seems, perhaps, esoteric. But applying several sets of filters often reduces a very large and nearly incomprehensible table to a smaller subset of data that provides just the information that you need.

Although the Custom AutoFilter dialog box does enable you to filter a list based on two criteria, sometimes filtering operations apply to the same field. And if you need to apply more than two filtering operations to the same field, the only way to easily do this is to filter a filtered table.