这个再试试
D4单元格
=REPT("重复:",IF(COUNT(FIND($A4,G$4:G$11))>1,1,0))&IFERROR(IF(COLUMN(A$1)=1,"","、")&INDEX($F:$F,SMALL(IF(1-ISERR(FIND($A4,$G$4:$G$11)),ROW($4:$11)),1)),"")&IFERROR(IF(COLUMN(B$1)=1,"","、")&INDEX($F:$F,SMALL(IF(1-ISERR(FIND($A4,$G$4:$G$11)),ROW($4:$11)),2)),"")&IFERROR(IF(COLUMN(C$1)=1,"","、")&INDEX($F:$F,SMALL(IF(1-ISERR(FIND($A4,$G$4:$G$11)),ROW($4:$11)),3)),"")
Ctrl+Shift+Enter三键同按,向下拖动复制公式 |