View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lupe Lupe is offline
external usenet poster
 
Posts: 30
Default Find duplicate records and delete

Hi,
I have a list with children and the name of the parents. I need to send
letters to the parents but when there is more than one child per parent, the
parent's name appears more than once. I have used Ron de Bruin's code to
replace the duplicate entries with a character. It works just fine, but in
my case I want to delete the duplicate records at once. How can I do this?
Thanks, Lupe