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.

[ennykraft]

The resolution is too small to read what you're doing.