how do i get rid of doubles from my database?

B

Bill

i have a large database with many of the email address' doubled or tripled,
how can i easily filter all the doubles out?
 
J

Jacob Skaria

--Select the Column with data including the header. You need to have header
for this column..Say Col A
--From menu Data>Filter>Advanced Filter>Copy to another location
--In 'copy to' selected another cell say G1 and check 'Unique records only'
--Click OK will give you the unique list in Col G
 
N

nancy0123 via OfficeKB.com

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

Need Help with Macro Security 1
how do I double or triple an existing EXEL file 6
Visio shape text disappears upon copy paste 1
Create booklet pdf w cover page and inside pages as double spread 1
I donot want to make double entry in excel sheet? 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Merging from an Excel file with graphics 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top