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
转载于:https://www.cnblogs.com/LYDXY/p/7403804.html