Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get rid of doubles from my database?
i have a large database with many of the email address' doubled or tripled,
how can i easily filter all the doubles out? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get rid of doubles from my database?
--Select the Column with data including the header. You need to have header
for this column..Say Col A --From menu DataFilterAdvanced FilterCopy 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get rid of doubles from my database?
Its best option try this -
DataFilterAdvanced 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.a...excel/201004/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing doubles | Excel Worksheet Functions | |||
Sorting doubles | Excel Discussion (Misc queries) | |||
Complex Formula to Find Doubles | Excel Worksheet Functions | |||
Cell height doubles after paste | Excel Discussion (Misc queries) | |||
How do I set up a Doubles Tennis roster for 12 players? | New Users to Excel |