This shows you the differences between two versions of the page.
— |
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. | ||
+ | | ||