[b]data dup[/b]

[mandyweems]

i have a data base and it hase rows of peoples info. and there are many duplicates. i need to delete all the duplicates but i cant mix up any of the rows so that i can do a mail merge later.
im so confused

 

[Tazguy37]

You could use Autofilter to filter for duplicates, and copy the unique records to another sheet. Much less complicated than deleting them. Hope that helps!