TEXTJOIN funktion for rows with identical emails

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

How about

Formula:

Please Login or Register  to view this content.

In that case can you please supply a workbook that shows the problem?

Sure, here is a workbook. The Syntax is German, hope that is not a problem, not sure how to convert easily.Workbook TEXTJOIN function (GER).xlsx

Thanks for that, although it would have helped if you had included the formula that didn't work.
Try

Formula:

Please Login or Register  to view this content.

Amazing, thank you so much Fluff! It worked, this will save us a lot of time.

You're welcome & thanks for the feedback.