Channel: Sele Training

Category: Science & Technology

Tags: advanced excel functionsexcel tips and trickslambda more examplessele traininglambda function 2021microsoft 365 lambdaexcel formulas and functionsexcellambdalambda recursionrecursive lambdaexcel 2020excel 2021lambda examplesexcel lambdalambda functionexcel dynamic array formulasexcel 2021 lambdaexcel lambda examples

Description: You asked for more examples of the brand-new Excel LAMBDA function. Here are some complex formulas that make better use of LAMBDA. Introduction to LAMBDA Video: youtu.be/Ayc7QOadBa4 Advanced Excel Functions Video: youtu.be/cnmPSlajJVM Dynamics Array Formulas Video: youtu.be/xwTUfU8PqCU Support me with your Amazon purchases, click here: amzn.to/2Kxp533 Contents 0:00 1. Count Words 0:23 2. Count Words Array 1:54 3. Most Frequent 3:19 4. Last Value 4:36 5. Filter List 6:05 CountWords =LAMBDA(words,LEN(TRIM(words))-LEN(SUBSTITUTE(TRIM(words)," ",""))+1) CountWordsArray =LAMBDA(words,SUMPRODUCT(LEN(TRIM(words))-LEN(SUBSTITUTE(words," ",""))+1)) MostFrequent =LAMBDA(list,INDEX(list,MODE(MATCH(list,list,0)))) LastValue =LAMBDA(list,name,INDEX(list,MAX(IF(list=name,ROW(list)-MIN(ROW(list))+1)),2)) FilterList =LAMBDA(range,year,category,product,FILTER(range,IF(year="",1,OFFSET(range,0,0,,1)=year)*IF(category="",1,OFFSET(range,0,1,,1)=category)*IF(product="",1,OFFSET(range,0,2,,1)=product),"")) #seletraining #excel #lambda