excel中一列中查找重复

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

posted @ 2017-08-21 13:04  LYDXY  阅读(356)  评论(0编辑  收藏  举报