how do i get rid of doubles from my database?

  • Thread starter Thread starter Bill
  • Start date Start date
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?
 
--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
 
Back
Top