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)))
)
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