Excel FILTER Function - Is this the Best Excel Function?

This video is an introduction to the FILTER function of Excel - is this the best Excel function? Download the file used in the video - https://www.computergaga.com/_excel/files/youtube-filter-function.xlsx This is the completed version - https://www.computergaga.com/_excel/files/youtube-filter-function-completed.xlsx Learn over 150 of the best functions in Excel - https://amzn.to/3Rg87Go The Excel FILTER function is incredibly versatile and powerful. It is a utility function in Excel that can help with many tasks Excel users need to perform. This Excel formula can be used to lookup and return multiple matches. A common issue with other lookup formulas that the FILTER function solves. You can also easily lookup with multiple criteria with this function. Excel lookup multiple matches and multiple criteria. And it can do much more. This must be the best Excel function. 00:00 Introduction 00:22 The FILTER function in Excel 05:40 FILTER with multiple criteria 07:50 Return all the results, if no criteria is used with the IF function 09:47 VLOOKUP to return related data for FILTER results 11:29 Edit FILTER to return single columns 13:28 Aggregate the FILTER results