EXCEL,一列有两个相同的字符串,想同时筛出来,在某个单元格里面显示出来...答:C2公式:=IFERROR(INDEX(A$2:A$100,SMALL(IF(MATCH(A$2:A$100&"",A$2:A$100&"",)=ROW($1:$99),ROW($1:$99)),ROW(A1)))&"","")数组公式,按CTRL+SHIFT+回车,完成公式,下拉;D2公式:=IFERROR(INDEX($B$2:$B$100,SMALL(IF($A$2:$A$100=$C2,ROW($1:$99)),COLU...
查找EXCEL单元格内重复出现的字符串,并截取。答:=MID(REPLACE($A1,1,1,"-"&LEFT($A1,1)),FIND("*",SUBSTITUTE(REPLACE($A1,1,1,"-"&LEFT($A1,1)),"-","*",COLUMN()-1))+1,FIND("#",SUBSTITUTE(REPLACE($A1,1,1,"-"&LEFT($A1,1)),"-","#",COLUMN()))-FIND("*",SUBSTITUTE(REPLACE($A1,1,1,"-"&LEFT($A1,1...