eliminate duplicates on a sheet

  • Thread starter Thread starter C. Brown
  • Start date Start date
C

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?
 
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
 
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
 
Back
Top