User Tools

Site Tools


duplicates

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

duplicates [2017/10/20 16:17] (current)
zeppo created
Line 1: Line 1:
 +In Excel, you have several ways to filter for unique values or remove duplicate values:
 +
 +      * To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.
 +
 +      * To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.
 +
 +      * To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
 +    ​
  
duplicates.txt ยท Last modified: 2017/10/20 16:17 by zeppo