Consider a single column with values where some may be duplicates. To remove duplicate values and obtain only the unique entries in the column:

• 1. Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column.

• 2. Go to Data - More Filters - Standard Filter. This opens the Standard Filter dialog.

• 3. In Field Name make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically.

• 4. In Condition choose the option = (equals sign), which is the default option.

• 5. In Value choose the option Not Empty.

• 6. Click Options and select No duplications. If the first value is the column header check Range contains column labels.

• 7. Check Copy results and use the input box below it to inform a cell address where the unique entries are to be entered.

• 8. Click OK. The unique values in the range will be entered starting with the cell selected in the previous step.
  

  
  
  • Previous
     
  • 1
    
  • 2
    
  • 3
    
  • 4
    
  • 5
    
  • 6
    
  • 7
    
  • 8
    
  • 9
    10  
  • 11
    
  • 12
    
  • 13
   
  • Next
    
  Last：SFree office免费文档PDF办公套件 Next：Return to list