View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Does anyone know of any 'Smart' Duplicate Remover?

HI
Maybe this :
http://www.ablebits.com/excel-remove...ates/index.php
HTH
John
"msnyc07" wrote in message
...
I have a table with many rows and duplicate values.

However 'Remove Duplicates' won't work since I need some rules to process
i.e. which records to remove and in some cases I want to combine.

For instance;

If I say Field1 and Field2 define duplicate records I don't want it to just
throw away the first dupe it finds. I want it to keep the record that has a
specified value in FieldC say SourceField<"" or SourceField="Wikipedia"

Alternately I may want to merge specific fields say if Record 1 has 'Blue'
in Color and Record 2 has 'Red' in color I don't want it to use first but to
concatenate so new/merged field has Red; Blue

Is that something that exists as either code or plug-in that anyone knows
of? I can't be the only one that needs more then just 'remove duplicates'...