Forum Discussion

reevesgetsaround's avatar
reevesgetsaround
Brass Contributor
Aug 31, 2023
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 31, 2023

    reevesgetsaround 

    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)
            ) )
        )
    )
)
reevesgetsaround's avatar
reevesgetsaround
Brass Contributor
Aug 31, 2023
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?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 31, 2023

reevesgetsaround 

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)
            ) )
        )
    )
)
  • reevesgetsaround's avatar
    reevesgetsaround
    Brass Contributor
    Sep 01, 2023
    Thank You Hans and Sergei, both methods work excellently.

    Best Regards

Resources