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 will only return unique results in the case of Gas on Apartment 3.
I'd be very grateful for some help adding these conditions in.
Many Thanks
S
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) ) ) ) ) )
