Excel 365 Tutorial: FILTER tutorial with LAMBDA function

Example of the FILTER() function in action, and examples of how to use a LAMBDA in the criteria inputs. Timecodes: 0:00 - Intro 0:22 - FILTER() 0:29 - Alternate ways to define criteria columns 1:20 - Value to return if no filter matches are found 1:45 - Add second AND criteria 2:19 - Partial string match in criteria 3:40 - OR criteria method 4:32 - LAMBDA() function 7:40 - More complex LAMBDA() function; optional arguments, split paths with CHOOSE() function. Visit our business homepage: https://mycostpro.com