Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Entries
I get a report once a month that has duplicate entries. I would like to take
out all the duplicate entries. Is there a formula I can use for this or what would be the easiest way of taking out the duplicate entries. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Entries
You can use Advanced Filter to extract unique records. I find it easier
to copy the records (with headings) to a different sheet, then Data | Filter | Advanced Filter - click on Unique Records only, and if you want the unique records to be copied to a different location (rather than In Place) you need to specify the first cell of the range. Another way is to sort your data (let's say on column A), then introduce a helper column with this formula in row 2: =IF(A1=A2,"duplicate","unique") Copy this down the column, then apply a filter to these values, selecting "duplicate". Highlight all the visible rows then Edit | Delete Row. You can set the filter back to "All", then delete the helper column. Hope this helps. Pete Phxlatinoboi® wrote: I get a report once a month that has duplicate entries. I would like to take out all the duplicate entries. Is there a formula I can use for this or what would be the easiest way of taking out the duplicate entries. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Entries
DataFilterAdvanced Filter.
Check "unique records only" and "copy to a new location". For more on this see Debra Dalgleish's site http://www.contextures.on.ca/xladvfi....html#FilterUR Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 17:01:02 -0700, Phxlatinoboi® wrote: I get a report once a month that has duplicate entries. I would like to take out all the duplicate entries. Is there a formula I can use for this or what would be the easiest way of taking out the duplicate entries. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing duplicate entries | Excel Discussion (Misc queries) | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
problem tagging duplicate entries | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |