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
Watch video Excel 365 Tutorial: FILTER tutorial with LAMBDA function online without registration, duration hours minute second in high quality. This video was added by user Excel 101 05 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 243 once and liked it 3 people.