重复大于或等于二次的数据 ?

wooikeat9128

像黄色区块呈列出来

cutecpu

E3 陣列公式:
=IFERROR(
VLOOKUP(
1,
IF({1,0},(COUNTIF($A$2:$A$17,$A$2:$A$17)>=2)*(COUNTIF(E$2:E2,$A$2:$A$17)=0),$A$2:$A$17),
2,)
,"")

※陣列公式，請記得按Ctrl+Shift+Enter

※如果有解決您的問題，再請將帖子設為[已解決]

祝順心，南無阿彌陀佛！

gykg-excel

=IFERROR(INDEX(A:A,SMALL(IF((COUNTIFS($A$2:$A$17,$A$2:$A$17,$B$2:$B$17,B$2:$B$17)>=2)*(MATCH($A$2:$A$17,$A$2:$A$17,)=ROW($A$2:$A$17)-1),ROW($A$2:$A$17)),ROW(A1))),"")