so i want to concat a list of value in column K if the condition in column J and G are true.
im expecting that a can get the list of that and seperate it with coma like i already put it in column A – E, the formula will be in column B and im expecting to use the formula with the help of arrayformula. Im also put a note on cell B2 for some short explanation you can check it here :
https://docs.google.com/spreadsheets/d/1LwdHmtQhr5YlHzMw6DOcpYW0v1XfCgHCf1CSk9-xF6k/edit?usp=sharing
Thanks in advance!
>Solution :
You may try:
=map(A2:A,lambda(Σ,if(Σ="",,textjoin(", ",1,ifna(filter(E:E,D:D=Σ))))))
