Array Formula

Copper Contributor

Hi,
I need to insert an Array Formula in the middle of a regular formula. 
For example:
=CONCATENATE(if(iferror(if(VLOOKUP(G5;Eventos!$A:$C;3;false)="";"";VLOOKUP(G5;Eventos!$A:$A;1;false));"");"[Evento] ";"");ArrayFormula(textJoin(Char(10)&"[Evento] ";true;REPT(Eventos!$C:$C;Eventos!$A:$A=G5))))
I'm trying to do this in portuguese. Isn't necessary to put "{"? . When I press CTRL+SHIFT+ENTER the "{" goes to the beginning and the and of entire formula, but the array formula is only from "textjoin" on.

 

How can I do that?

 

Thanks!

Regards
Francisco Alves

3 Replies

Hi Francisco,

 

That's only entire formula could be array (entering by Ctrl+Shift+Enter) or regular one (just Enter)

It is was I thought, but this particular formula really exists. I saw her workig in a Google spreadsheet. But I'm not able to make it work in my Excel spreadsheet. 
What I need to do is as follows: I have a list of things to do by date. For example:

3/1/2019 - go to the doctor

3/1/2019 - do a job

3/2/2019 - call Marcy to talk about the job
Than I have a calendar where each cell I will concatenate all things-to-do for each date using a formula that brings all items in the left row corresponding to each date. Example:

3/1/2019 - go to the doctor / do a job

There is a possibility to insert new items with same date. Example:

3/1/2019 - go to the doctor

3/1/2019 - do a job

3/1/2019 - study for the test

3/2/2019 - call Marcy to talk about the job

 

.

You may use array formula like this

image.png

=TEXTJOIN(CHAR(10),TRUE,IF($A$1:$A$3=D1,$B$1:$B$3,""))