eliminate duplicates on a sheet

[C. Brown]

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

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/Duplicates.aspx

 

[David Billigmeier]

You can bring it into a pivot table, then drag the names and addresses on to
the Row Labels. The pivot table will automatically only display the unique
values

 

[Ashish Mathur]

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