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
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"))))
Great! No one would find this creation so easily. All the best. Best wishes for success in all your creations. Cheers. RK
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
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"))))
Thank you for this great video
but I wonder why it doesn't work with IFS instead of IF
Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic
Thanks