Examples of using The duplicate values in English and their translations into Portuguese
{-}
- 
                        Colloquial
                    
- 
                        Official
                    
- 
                        Medicine
                    
- 
                        Financial
                    
- 
                        Ecclesiastic
                    
- 
                        Ecclesiastic
                    
- 
                        Computer
                    
- 
                        Official/political
                    
In the Duplicate Values dialog, select Duplicates  from left drop down list,
Note: If you need to remove the  whole rows of the duplicate values, please check Select entire rows in the  Select Duplicate& Unique cells dialog box,
This helps to quickly find the duplicated values, by having a set of colors each of which can readily be distinguished from one another.
you can only unmerge cells without filling down the duplicate value in the  unmerge cells.
the name of the  offending table and field,">as well as the duplicated value.
keep the  first row where the duplicated value is found.
click OK to close the  dialogs, then the duplicates values are kept selected
This tool counts and colors the duplicate values in your selection.
Now all unique cell rows are deleted and only the duplicate values kept.
Click Ok, then the duplicate values have been deleted
And the  merged cells have been unmerged and filled with the duplicate values at once.
Click OK, now the duplicate values have been removed from selection
In Excel, you can use the  Conditional Formatting feature to color the duplicate values or rows.
It means giving a sequential order for the duplicate values or unique values  as following screenshot shown.
a dialog pops out to remind you that the duplicate values have been selected.
In the  Column section, select the  column which contains the duplicate values, and click the  Primary Key;
If you just want to mark the duplicate values, you can apply a formula to make it outstanding.
After totally excluding the duplicate values, the  count of the  unique values  based on above data will be 4.
range of cells which you want to prevent the duplicate values but allow only unique data.