連接與不連接 為提取條件 (14477)

C2{=INDEX(A:A,SMALL(IF((MMULT(1-ISERR(FIND({"公司","合伙","廠","工廠"},A$2:A$99)),{1;1;1;-9})>0)*(LEN(A$2:A$99)>5),ROW($2:$99),99),ROW(A1)))&""