how do i get rid of doubles from my database?
in [General]
|
Prev: Please help to search a custom format
Next: unable to cast ..Excel.ApplicationClass to ..Excel._Application
From: Bill on 27 Apr 2010 01:46 i have a large database with many of the email address' doubled or tripled, how can i easily filter all the doubles out?
From: Jacob Skaria on 27 Apr 2010 01:55 --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 -- Jacob (MVP - Excel) "Bill" wrote: > i have a large database with many of the email address' doubled or tripled, > how can i easily filter all the doubles out?
From: nancy0123 via OfficeKB.com on 27 Apr 2010 02:55
Its best option try this - Data>Filter>Advanced Filter Bill wrote: >i have a large database with many of the email address' doubled or tripled, >how can i easily filter all the doubles out? -- #1 Data Recovery Services Stellar Information Systems Ltd. D18, Sector-33, Infocity Phase II, Gurgaon-122001 Phone : (0124) 326 6069, 432 6700 Website : http://www.stellarinfo.co.in/ Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201004/1 |