Forum Discussion

CFYeap's avatar
CFYeap
Copper Contributor
Aug 02, 2022
Solved

ARRAYTOTEXT with CELL function doesn't work?

Hi, I am trying to generate a list (text) from my data and I couldn't get the ARRAYTOTEXT to work. I am using Microsoft 365 version 2206 64 bit (15330.20264 click-to-run), running on Windows 10. Plea...
excel
Formulas and Functions
office 365
  • Lorenzo's avatar
    Lorenzo
    Aug 03, 2022

    Hi CFYeap 

     

    Alternatively, in 'generate list'!D6:

    =LET(
    From, XMATCH(C2,Table1[Date]),
    To,   XMATCH(C3,Table1[Date]),
    TEXTJOIN(CHAR(10),,INDEX(Table2[Event], SEQUENCE(To-From+1,,From)))
)
Lorenzo's avatar
Lorenzo
Silver Contributor
Aug 03, 2022

Hi CFYeap 

 

Alternatively, in 'generate list'!D6:

=LET(
    From, XMATCH(C2,Table1[Date]),
    To,   XMATCH(C3,Table1[Date]),
    TEXTJOIN(CHAR(10),,INDEX(Table2[Event], SEQUENCE(To-From+1,,From)))
)
  • CFYeap's avatar
    CFYeap
    Copper Contributor
    Aug 04, 2022
    Wow, both Riny_van_Eekelen and Lorenzo 's methods worked. They are simpler than the workaround I thought of later using concat().
    Thank you both for the help!
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Aug 04, 2022
      CFYeap. Glad we could help & Thanks for providing feedback

Resources