| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Try this simply
To filter for unique values, click Data Sort & Filter Advanced. To remove duplicate values, click Data Data Tools Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
Regards, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate Duplicate Row | Excel Discussion (Misc queries) | |||
| how to eliminate duplicate numbers | Excel Worksheet Functions | |||
| Create a macro to eliminate certain words from several columns | Excel Worksheet Functions | |||
| How to eliminate duplicate entries | Excel Discussion (Misc queries) | |||
| macro to eliminate spaces between words | Excel Discussion (Misc queries) | |||
Threaded Mode
