Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. =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))
  2.  
  3. =MID(CONCAT(IF(C2:J2=1,$C$1:$J$1&",","")),1,LEN(CONCAT(IF(C2:J2=1,$C$1:$J$1&",","")))-1)
  4.  
  5. =IF(SUM(C2:J2)>1,"Yes","No")
  6.  
  7. =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))
  8.  
  9. ($L$2:$O$9=$L2)*($L2<>"")
  10.  
  11. +($L$2:$O$9=$M2)*($M2<>"")
  12.  
  13. =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