Forum Discussion

mkglen's avatar
mkglen
Copper Contributor
Nov 01, 2023

Problem with IF formula

I am trying to get column S to list pickup days if columns N, O, P, Q, R have a value in them. My formula =IF(N2<>"","M, ",IF(O2<>"","T, ",IF(P2<>"","W, ",IF(Q2<>"","H, ",IF(R2<>"","F, ",""))))) is o...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 01, 2023

mkglen 

=BYROW(N2:R6,LAMBDA(x,TEXTJOIN(",",,FILTER(N1:R1,NOT(ISBLANK(x))))))

 

With Office 365 or Excel for the web you can apply this formula.

  • Heather970's avatar
    Heather970
    Copper Contributor
    Nov 01, 2023
    For non web or 365 users you could shorten this to
    =TEXTJOIN(", ",,FILTER($N$1:$R$1,NOT(ISBLANK(N2:R2))))

Resources