Forum Discussion
Solved
Alteration to TEXTJOIN IF formula
Hi all I have a formula in G2 of the attached sample doc. I'm trying to develop it so that it will only return results where the Risk number is greater than, let's say 3. But also, so that it wil...
In addition, you may return all results at once
=BYROW( $F$2:$F$5, LAMBDA(v, TEXTJOIN(", ", , UNIQUE( FILTER( $B$2:$B$13, ($A$2:$A$13 = v) * ($C$2:$C$13 > 3) ) ) ) ) )
Thank You Sergei, that certainly fixes the duplication aspect. But is it possible to add in a condition which will only return results when the Risk number in column C is greater than 3, for example?
In addition, you may return all results at once
=BYROW( $F$2:$F$5, LAMBDA(v, TEXTJOIN(", ", , UNIQUE( FILTER( $B$2:$B$13, ($A$2:$A$13 = v) * ($C$2:$C$13 > 3) ) ) ) ) )- Thank You Hans and Sergei, both methods work excellently.
Best Regardsreevesgetsaround , you are welcome
=TEXTJOIN(", ", , UNIQUE( FILTER($B$2:$B$13, ($A$2:$A$13 = $F2)*($C$2:$C$13>3) ) ) )
