Dear All

This is my first post here - hellooo!


I am working on a formula to join the texts of column A into one cell in column B, whenever the rows share a common variable (the Email-Adress, in column P). The formula I came up with is:

{=TEXTJOIN(CHAR(10);TRUE;IF(P4:P10002=1; A4:A10002;""))}

The result is that all cells in column B, where I pasted the formula, come up blank. There are no blank cells in columns A and P.

Can you help me solve this?

Warmly

Yannic