Excel's custom function editor: Create, & reuse LAMBDAs in new files
Custom functions were classically made in VBA but new as of Feb 2022 you can create your own in Excel's native app. The new add-in advanced formula environment, makes this much easier to both create and if you just want to reuse other people's custom LAMBDA functions.
I will go through examples, installing, creating & reusing with the advanced formula environment, and even how to have your LAMBDAs appear on all new files. I will showcase three I built, COUNTUNIQUE, COUNTUNIQUEIF and TEXTJOINIF, if you want the workbook I have used you can leave a comment & subscribe to my channel.
Links: LAMBDA helper functions: https://techcommunity.microsoft.com/t...
LAMBDA & adv. formula environment announcement: https://techcommunity.microsoft.com/t...
Example files can be found here: www.xlconsulting-asia.com/youtube-files
00:00 - Introduction
03:07 - Get Advanced Formula Environment
04:24 - Import LAMBDAs
04:47 - Import LAMDDA library
06:03 - Copy LAMBDA from another workbook
07:11 - Create a LAMBDA through the editor
09:48 - Troubleshoot issues with the editor
10:51 - Create LAMBDAs without an editor
11:38 - DISTINCTCOUNTIF & TEXTJOINIF Demo
13:27 - Advanced formula env tips
14:26 - Version for LAMBDA
15:20 - LAMBDA helper functions & recursive
16:03 - Have LAMBDAs in any new file