查找条件全出現 提出 (11417)

D1{=INDEX(B:B,SMALL(IF(MMULT(1-ISERR(FIND(TRIM(MID(SUBSTITUTE(C$1," ",REPT(" ",99)),COLUMN($A:$J)*99-98,99)),$B$1:$B$7)),ROW(1:10)^0)=10,ROW($1:$7),99),ROW(A1)))&""