Forum Discussion
Solved
Can it be done?
I'm struggling getting a formula to work and unsure if it's possible. Basically I have a bank of data, I want to use Textjoin to amalgamate the references in column N based on the same customer in ...
Hi John,
How do you check the date? That could be like
{=TEXTJOIN(CHAR(10),TRUE,IF(($C$1:$C$242=C2)*($K$1:$K$242=K2),$N$1:$N$242,""))}
Hi John,
How do you check the date? That could be like
{=TEXTJOIN(CHAR(10),TRUE,IF(($C$1:$C$242=C2)*($K$1:$K$242=K2),$N$1:$N$242,""))}
Hi Sergei,
That worked an absolute treat!! Thank you VERY much for that!!