Hi,

You could also use Advanced Filters. In the advanced filters dialog box,
there is a check box for unique records only. Also, when selecting the list
range and criteria range, please select the header row

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"C. Brown" wrote in message
...
I have a list of 3500 names & addresses in an Excel workbook on one sheet
and
some are duplicates. How do I eliminate duplicates?