Excel 365 Tutorial: FILTER tutorial with LAMBDA function

Published: 05 November 2023
on channel: Excel 101

609

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

On this page of the site you can watch the video online Excel 365 Tutorial: FILTER tutorial with LAMBDA function with a duration of hours minute second in good quality, which was uploaded by the user Excel 101 05 November 2023, share the link with friends and acquaintances, this video has already been watched 609 times on youtube and it was liked by 4 viewers. Enjoy your viewing!

158