Hello,
I read many posts but could not find any help for my problem. See attachment of an example.
I want to Concatenate many expressions/words from the column B in one cell (N10), but only if the date in row 7 matches the date in cell M10 AND if the values in the column D are greater than zero.
For N11 the date should match the date in the cell M11 and values >0 in column E
and so on...
Hos should the formula should look like to manage my problem.
I tried a lot: lookupconcat, If(Concatenate(Vloopup... but could not find a solution)
Thank you a lot for your help in advance.
View attachment Example.xlsx
I read many posts but could not find any help for my problem. See attachment of an example.
I want to Concatenate many expressions/words from the column B in one cell (N10), but only if the date in row 7 matches the date in cell M10 AND if the values in the column D are greater than zero.
For N11 the date should match the date in the cell M11 and values >0 in column E
and so on...
Hos should the formula should look like to manage my problem.
I tried a lot: lookupconcat, If(Concatenate(Vloopup... but could not find a solution)
Thank you a lot for your help in advance.
View attachment Example.xlsx