=IF(COUNTIF(D:D,D1)>1,”有重复”,””

D=相应列

 

=MID(A1,MIN(IFERROR(FIND(TRANSPOSE(ROW($130:$189)),A1),9999)),11)

把这个公式复制到b1 单元格 然后按 ctrl+shift+enter