Excel LAMBDA Recursion, recursion, echo...

Поділитися
Вставка
  • Опубліковано 2 жов 2024

КОМЕНТАРІ • 6

  • @RamakrishnanRukmini
    @RamakrishnanRukmini 3 роки тому +1

    Great! No one would find this creation so easily. All the best. Best wishes for success in all your creations. Cheers. RK

  • @patrickschardt7724
    @patrickschardt7724 3 роки тому +2

    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

  • @kailash680
    @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"))))

  • @abdelkrimmesaiahmed662
    @abdelkrimmesaiahmed662 3 роки тому

    Thank you for this great video
    but I wonder why it doesn't work with IFS instead of IF

  • @mauricestillsecret4807
    @mauricestillsecret4807 3 роки тому +1

    Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic

  • @George-lp3qb
    @George-lp3qb Рік тому

    Thanks