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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify duplicate rows
To flag the duplicates for filtering see Chip Pearson's site.
http://www.cpearson.com/excel/Duplicates.aspx Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 15:58:19 -0700, Joe wrote: 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? |
Reply |
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 |