Excel中一列数据，查找中间的重复项:
1. select the column which you want to search duplicate value
2. Home->Conditional Formatting(locate in styles)->HighLight Cells Rules->Duplicate Values...->Light Red Fill with Dark Red Text->OK
Excel中一列数据，查找中间的重复项:
1. select the column which you want to search duplicate value
2. Home->Conditional Formatting(locate in styles)->HighLight Cells Rules->Duplicate Values...->Light Red Fill with Dark Red Text->OK