Forum Discussion

tboulden's avatar
tboulden
Iron Contributor
Feb 13, 2021

Recursive Lambda: Unpacking LET function

RecentlyTwifoo posted the FIFO Inventory challenge, and PeterBartholomew1 ventured "shouldn't take lori_m more than a few minutes to write a recursive Python script to reduce any LET function back to...
excel
Formulas and Functions
rachel's avatar
rachel
Iron Contributor
Apr 06, 2024

TTodorov 

Oh, I see "|" is the mark down. 

 

What is supposed to happen when there is "For all"? 

 

TTodorov's avatar
TTodorov
Copper Contributor
Apr 06, 2024

rachelSeems that in my Excel (version 2308, build 16731.20600), TEXTSPLIT with ARRAYTOTEXT not working. I tried to recreate your data (with "|") and the result seems like this:

 

At general, result is correct, but not possible to split it.

  • rachel's avatar
    rachel
    Iron Contributor
    Apr 06, 2024

    TTodorov 

    INDEX understands what "string" means.

    Below should work for two columns. (I put your data in range A1:B4).

    (Also, I guess your "for all" issue might have something to do with space).

    =ARRAYTOTEXT(
    MAP(
        SEQUENCE(ROWS(A1:A4), 1, 1, 1),
        LAMBDA(row_index,
            LET(
                data, A1:B4,
                xs, TEXTSPLIT(INDEX(data, row_index, 1), ","),
                ys, TEXTSPLIT(INDEX(data, row_index, 2), ","),
                ARRAYTOTEXT(xs & "-" & TRANSPOSE(ys))
            )
        )
    )
)

     

     

    • TTodorov's avatar
      TTodorov
      Copper Contributor
      Apr 06, 2024

      rachelARRAYTOTEXT produce array which seems to not possible to split it to list (as I need):

       

      Seems that TEXTSPLIT as your first suggestion from an array is not possible for me.

      • rachel's avatar
        rachel
        Iron Contributor
        Apr 06, 2024
        Are you sure you use semi-colon instead of comma when you TEXTSPLIT?
        =TEXTSPLIT(data, ";")?

Resources