EXCEL LAMBDAS explained with a simple example

⬇️ ... What are Excel LAMBDAs. LAMBDA functions in EXCEL can be very simple and the Excel Labs formula editor makes life very easy
📺 See the Part 2 follow on video with 3 tips on LAMBDAS:
• EXCEL LAMBDA tips (see...
⏬The File:
aasolutions.sharepoint.com/:f...
Here's the GIST you can use
gist.github.com/wynhopkins/91...
plus check out a previous video I did which shows more Lambdas
• What is LAMBDA in Excel
gist.github.com/wynhopkins/2e...
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

[@terrylee2094]

I was a little apprehensive of lambdas before this video. Thanks Wyn, a simple start will quench my thirst for more.

[@AccessAnalytic]

That’s great to hear Terry. Thanks for taking the time to let me know.

[@zm2813]

simple and practical. Thank you

[@AccessAnalytic]

You're welccome. Thanks for taking the time to leave a kind comment

[@juanbon5996]

Useful!!!! Indeed.

[@AccessAnalytic]

Thank you.

[@Chillman666]

Very cool!

[@AccessAnalytic]

Thank you

[@tranvinhthinh8825]

Great!!!❤

[@AccessAnalytic]

Thanks

[@henryg5735]

excellent, thank you 👍

[@AccessAnalytic]

You’re welcome

[@abdelazizallam]

awesome

[@AccessAnalytic]

Thanks

[@danre64]

This is awesome

[@AccessAnalytic]

😀

[@ianwilliams4436]

Wonder if there’s a performance boost over using a user defined function in VBA? 🤔 One way to find out…

[@AccessAnalytic]

Note too that Lambdas will work in Excel for web so a bit more future proof.

[@paulmartinlife]

This looks great for a single user, but I'm wondering whether it would work for me in a corporate environment where I'm distributing files to maybe 200 users. What's needed for distributed files? Do they all need to follow the installation process?

[@AccessAnalytic]

No the formula lives in the file. The add-in just assists in writing the formula

[@lynnetitley7976]

Nice one Wyn, thanks! I was aware of the term and it's been on my list to look into for a while. This is an accessible and effective intro - not scary at all 😉

[@AccessAnalytic]

Great to hear, thanks!

[@paulmartinlife]

@@AccessAnalytic great, thanks for the clarification

[@IvanCortinas_ES]

I imagine that the purpose of saving the function within a module is so that it can be called later from a new workbook. It's right?

[@AccessAnalytic]

Hi, no it’s just a method of grouping/categorising your LAMBDAS
Check out part 2 ua-cam.com/video/gUkC73uiROE/v-deo.html for how to use in other workbooks

[@JonathanExcels]

Can you save them in your personal macro workbook like a UDF?

[@AccessAnalytic]

Hmmm.. maybe … not sure I’d recommend it as the formula then wouldn’t work for anyone else.