因为*被当作通配符了，改用这公式=IFERROR(INDEX($A:$A,SMALL(IF(MATCH(SUBSTITUTE(A$1:A$100,"*","+")&"$",SUBSTITUTE(A$1:A$100,"*","+")&"$",0)=ROW($1:$100),ROW($1:$100),9^9),ROW(A1)))&"","")同时按ctrl+shift+回车结束
