部分重复的参数找出来 (12366)

E2{=INDEX(A:A,SMALL(IF(COUNTIF(A:A,LEFT(A$1:A$23,9-(FIND("-",A$1:A$23)=3))&"*")-1,ROW($1:$23),99),ROW(A1)))&""

另解{=INDEX(A:A,SMALL(IF(COUNTIF(A:A,LEFT(A$1:A$23,8+(MID(A$1:A$23,9,1)<"A"))&"*")>1,ROW($1:$23),99),ROW(A1)))&""