C1=TRIM(IF(COUNTIF($A$1:$A1,$A1)=1,SUBSTITUTE(PHONETIC(OFFSET(A1,,,4,2)),A1,"
"),""))
下拉
C1输入公式,先向右拉公式在向下拉
=IF(COUNTIF($A$1:$A1,$A1)=1,IFERROR(INDEX($B:$B,SMALL(IF($A$1:$A$100=$A1,ROW($1:$100)),COLUMN(A1))),""),"")
数组公式按ctrl+enter+shift
内容全部来源于网络收集，如有侵权，请联系网站删除！