I QUIT using Excel Filters After Learning This
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.
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
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
https://www.myonlinetraininghub.com/excel-functions/excel-filter-function
https://www.youtube.com/watch?v=ZCQAweoAdOw
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.