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 It is a formula equivalent to the filter feature of Excel. It returns a range of results that meet specific criteria. This range can then be placed on a worksheet or inside another formula. The potential is massive. This video shows some examples of what it is capable of. But a function is vast really needs further exploration from you. There will be many more videos to show why this is probably the best function in Excel. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1