Forum Discussion
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
.
You may use array formula like this
=TEXTJOIN(CHAR(10),TRUE,IF($A$1:$A$3=D1,$B$1:$B$3,""))