eliminate duplicates on a sheet

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?
 
D

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I remove duplicate photos from my flash drive 1
how to eliminate duplicate numbers 5
how to perform a deduplication of names on large mailing list 1
Removing Duplicates to another sheet 1
how to sort addresses in microsoft excel 2
using duplicate function 13
How to assign unique number to column duplicates? 3
Remove Duplicates logic 2

Top