I QUIT using Excel Filters After Learning This
Sep 11, 2022 12:00 AM

I QUIT using Excel Filters After Learning This

by HubSite 365 about Ready Steady Excel

Pro UserExcelLearning Selection

Learn why I stopped using filters in Excel and what I use instead. Auto filters are okay but they have some flaws that can prove costly, especially when dealing with financial accounting data.

In this video, I will show you how to use an Excel Function, that is a more reliable option when filtering data in your spreadsheet, helping to feel confident that you have captured the information correctly.

More about Excel Filter Function

FILTER function - The FILTER function allows you to filter a range of data based on criteria you define.


Excel FILTER Function

The Excel FILTER function returns a range filtered on criteria you define. It can also handle multiple AND/OR criteria. The FILTER function is part of the new Excel Dynamic Arrays family. At the time of writing, Dynamic Arrays are only available in Microsoft 365. Excel 2019 will not have the Dynamic Array functions



Using the FILTER function in Excel (Single or multiple conditions)

The FILTER function in Excel is a very useful and frequently used function, that you will likely find the need for in many situations. Note that the FILTER function is only available in Microsoft Office 365, and Microsoft Office Online.