Forum Discussion

fjmalves's avatar
fjmalves
Copper Contributor
Jan 31, 2019

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

excel

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 31, 2019

    Hi Francisco,

     

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

    • fjmalves's avatar
      fjmalves
      Copper Contributor
      Jan 31, 2019

      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

       

      .

Resources