Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Legacy EVALUATE in LAMBDA: Build/Test LAMBDAs from Sheet tbouldenthis has started returning a #NAME error from the recent beta builds - are you experiencing the same issue ? Cheers Sam Re: LAMBDA Examples: Distance between two citiesThis is great !!! Thanks a lot for this lori_m - There is no autocomplete/parameter help - but we can live with that. Cheers SamRe: LAMDA to find last instance of a search string within another string tboulden I also realized that the same output can be achieved without iteration as below FINDALL =LAMBDA(txt,dl, LET( vPos,SEQUENCE(LEN(txt)), vChars,MID(txt,vPos,1), result,FILTER(vPos,vChars=dl), result)) Re: LAMDA to find last instance of a search string within another string tboulden Oh Wow !!! Thanks - I was struggling with this problem for quite some time and your solution is going to take most part of today for me to figure out. Also a great way of showing now the new Lambda helper functions (SCAN in this case) leads to a more elegant solution Thanks once again for your effort. Cheers Sam LAMDA to find last instance of a search string within another string Can some one help covert the below to a lambda function using recursion I am aware that this is possible using SUBSTITUTE - I was just wondering how to get LAMDBA to exit on Error when it is used recursively Cheers Sam SolvedRe: LAMBDA Examples: Distance between two cities lori_m Wow ! - How did you figure that out - I am going to give this a shot on my install and see how it goes. Cheers Sam Re: LAMBDA Examples: Distance between two cities Chris_Gross Are there plans to support names defined using LAMBDA functions to be distributed via Add-ins or are we back to PERSONAL.xlsb Cheers Sam Re: LAMBDA Examples: Distance between two cities Chris_Gross CellColor =LAMBDA(Rng, GET.CELL(63,Rng)) Crashes excel Any way to get this to work Cheers Sam
