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.
FILTER function - The FILTER function allows you to filter a range of data based on criteria you define.
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
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.