Hi,
I've got a TEXTJOIN formula to create a consolidated list of all fields with a date between 2 given dates.
It seemed to work when I first put it in and suddenly stopped and now I can't get it back ?
Any idea where I'm going wrong? Below is a simplified version of my sheet (The live one has 80 fields)
="◆"&TEXTJOIN(CHAR(10)&"◆",TRUE,IF(AND($E3:$H3>=J$1,$E3:$H3<=J$2),$E$1:$H$1,""))
I've got a TEXTJOIN formula to create a consolidated list of all fields with a date between 2 given dates.
It seemed to work when I first put it in and suddenly stopped and now I can't get it back ?
Any idea where I'm going wrong? Below is a simplified version of my sheet (The live one has 80 fields)
="◆"&TEXTJOIN(CHAR(10)&"◆",TRUE,IF(AND($E3:$H3>=J$1,$E3:$H3<=J$2),$E$1:$H$1,""))