| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify duplicate rows
I am blending a few contact lists into one excell sheet and would like to
find duplicates, then manually delete the ones I want. Is there a way to sort by a column (like Last name) and filter out all rows that are not duplicates? The result of this action would be a list of only duplicates that I can evaluate. If this can't be done is there a way to highlight duplicate rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create formula to identify duplicate cells? | Excel Worksheet Functions | |||
| Ways to identify types items with duplicate them, plz help! | Excel Discussion (Misc queries) | |||
| Need to identify duplicate entries in a Table | Excel Worksheet Functions | |||
| How do I identify duplicate numbers in Excel? | Excel Discussion (Misc queries) | |||
| identify duplicate enteries | Excel Worksheet Functions | |||
Threaded Mode
