Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Tom Hanks From A Lambda And Let Function In Excel – 2397

Posted on by Bb

Here is a cool example of a LAMBDA function with a LET and XMATCH function. Point to two cells that contain movie names and the function will find the cast who is in common between the two movies and provides the photo of those people in common.
If you want to play the Six Degrees of Separation of Kevin Bacon, download the Excel file from here: https://1drv.ms/x/s!As7G72Sl487JlgwqhYWHCWA41s8t?e=U8K5Yc

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comTue, August 10, 2021 4:09am