Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =MIN(IF(($K$2:$K$9=C$1)*(($L$2:$O$9=$L2)*($L2<>"")+($L$2:$O$9=$M2)*($M2<>"")+($L$2:$O$9=$N2)*($N2<>"")+($L$2:$O$9=$O2)*($O2<>"")),1))
- =MID(CONCAT(IF(C2:J2=1,$C$1:$J$1&",","")),1,LEN(CONCAT(IF(C2:J2=1,$C$1:$J$1&",","")))-1)
- =IF(SUM(C2:J2)>1,"Yes","No")
- =MIN(IF(($K$2:$K$9=C$1)*(($L$2:$O$9=$L2)*($L2<>"")+($L$2:$O$9=$M2)*($M2<>"")+($L$2:$O$9=$N2)*($N2<>"")+($L$2:$O$9=$O2)*($O2<>"")),1))
- ($L$2:$O$9=$L2)*($L2<>"")
- +($L$2:$O$9=$M2)*($M2<>"")
- =MID(CONCAT(IF(C3:J3=1,$C$1:$J$1&",","")),1,LEN(CONCAT(IF(C3:J3=1,$C$1:$J$1&",","")))-1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement