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 C. This works a treat with the formula:
[=TEXTJOIN(CHAR(10),TRUE,IF($C$1:$C$242=C2,$N$1:$N$242,""))]
However I then want to check if the date in K also agrees and if it doesn't, don't amalgamate the references.
I've attached a screenshot of the data
Can anyone help???
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,""))}
2 Replies
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!!
