二科目以上TRUE 提取 (15108)

H7:I13{=IFERROR(INDEX(A:A,SMALL(IF(MMULT($C$2:$F$21*1,{1;1;1;1})>1,ROW($2:$21)),ROW(A1))),"")

J7:M13{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($1:$1,SMALL(IF(($A$2:$A$21=$H7)*($B$2:$B$21=$I7)*($C$2:$F$21=(1=1)),{3,4,5,6}),COLUMN(A1)))&K7,"")



留言