I QUIT using Excel Filters After Learning This
Excel
11. Sept 2022 00:00

I QUIT using Excel Filters After Learning This

von HubSite 365 über 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.

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.

https://www.spreadsheetclass.com/excel-filter-function/