excel 找出重复项

e2=INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),)))f2=VLOOKUP(E2,$A$2:$B$9,2)

想去掉#REF显示的方法=IF(ISERR(INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),)))),"",INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),))))

=IF(ISERROR(VLOOKUP(G2,$A$2:$B$9,2)),"",VLOOKUP(G2,$A$2:$B$9,2))