Method 1: Highlight duplicate data
You can highlight repetitive data so you can find them and avoid repetitive entries. The procedure is as follows:
-
First, select the scope of the duplicate data you want to find. For example, if you are looking for duplicates in the employee number, select the "Employee Number" column.
-
Then on the
Start tab->
conditional formatting ->
highlight the cell rules ->
Duplicate values .
Put this picture away. expand this picture
-
On the
Duplicate Value dialog box, select the format you want to highlight the duplicates, and then
determine .
Put this picture away. expand this picture
-
Get! Repeat the content at a glance, so you can take appropriate measures slightly.
Put this picture away. expand this picture
Method 2: Easily remove duplicate data
You can use Excel to remove duplicate data and delete duplicates. The procedure is as follows:
-
Select the range for which you want to delete duplicate data. For example, select the entire table.
-
Then->
deletes duplicates on the
Data tab.
Put this picture away. expand this picture
-
dialog box. In which columns do you need to find duplicates, tick the list,
.
> close this picture
-