duplicates
Differences
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. | ||
| + | | ||
duplicates.txt ยท Last modified: 2017/10/20 16:17 by zeppo
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
