deleting duplicate rows

[scubahh]

Is there a function to identify and delete duplicate
rows? I've merged several worksheets resulting in over
6000 rows. I'd like to delete exact duplicates, and
they're there, without having to "eyeball" 6000+ rows.

 

[Ken Wright]

For a macro approach, take a look at the deleting duplicates section on Chip Pearson's site:-

http://cpearson.com/excel/deleting.htm

You might also want to look at formulas to identify them:-

http://cpearson.com/excel/duplicat.htm