• 410K Members
• 7,701 Online
• 466K Conversations

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

# Re: Array Formula

Hi Francisco,

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

# 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

.

# 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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies