• 540K Members
• 2,857 Online
• 644K Conversations

Highlighted
New Contributor

# Array Formula

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
Highlighted

# Re: Array Formula

Hi Francisco,

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

Highlighted

# Re: Array Formula

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

.

Highlighted

# Re: Array Formula

You may use array formula like this

`=TEXTJOIN(CHAR(10),TRUE,IF(\$A\$1:\$A\$3=D1,\$B\$1:\$B\$3,""))`
Related Conversations
Array Formulas Syntax - Matrix Calculations
ignacioch in Excel on
0 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies