Great! No one would find this creation so easily. All the best. Best wishes for success in all your creations. Cheers. RK
@patrickschardt7724
3 жыл бұрын
If you use the comment in the named range, it shows that in the screen tip before the parenthesis. Also once the recursive LAMBDA is named, it can be tested back in the worksheet like normal LAMBDAs. Just put the arguments in parentheses right at the end of the formula
@George-lp3qb
Жыл бұрын
Thanks
@mauricestillsecret4807
3 жыл бұрын
Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic
@abdelkrimmesaiahmed662
3 жыл бұрын
Thank you for this great video but I wonder why it doesn't work with IFS instead of IF
@kailash680
Жыл бұрын
Why not providing the formula or the example workbook? Here is it. "text" has previously caused problems for me, so I used "cellText" instead: =LAMBDA(cellText;Char;N;Counter; IF(N=0;"Choose a number greater than 0"; IF(N=Counter;IFERROR(LEFT(cellText;FIND(Char;cellText;1)-1);cellText); IFERROR(FindItem(REPLACE(cellText;1;FIND(Char;cellText);"");Char;N;Counter+1);"Not Found"))))
Пікірлер: 6