Jan 30 2019 06:45 PM
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
Jan 31 2019 01:14 AM
Hi Francisco,
That's only entire formula could be array (entering by Ctrl+Shift+Enter) or regular one (just Enter)
Jan 31 2019 02:16 AM
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
.
Jan 31 2019 03:11 AM
You may use array formula like this
=TEXTJOIN(CHAR(10),TRUE,IF($A$1:$A$3=D1,$B$1:$B$3,""))