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

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

sample data.xlsx20 KB

Forum Discussion

ARRAYTOTEXT with CELL function doesn't work?