Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone know if it'spossible to de-dupe a mailing list using excel
Hi I've merged 2 mailing list files and have noticed there are a few
duplicate records.Is there a way of de-duping in Excel?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone know if it'spossible to de-dupe a mailing list using excel
Hi,
Look CPearson web, go to the middle of the page where it says delete duplicate rows http://www.cpearson.com/excel/deleting.htm "Jonathan6315" wrote: Hi I've merged 2 mailing list files and have noticed there are a few duplicate records.Is there a way of de-duping in Excel?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone know if it'spossible to de-dupe a mailing list using excel
Check out this option.
--Select data range and from menu DataFilterAdvanced FilterCopy to another location.. --In 'copy to' select a cell and check 'Unique records only' --Click OK ..will give you the unique list -- Jacob (MVP - Excel) "Jonathan6315" wrote: Hi I've merged 2 mailing list files and have noticed there are a few duplicate records.Is there a way of de-duping in Excel?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone know if it'spossible to de-dupe a mailing list using excel
If you are using Excel 2007 you can use the 'Remove Duplicates' button on the
Data ribbon. Hope this helps, Hutch "Jonathan6315" wrote: Hi I've merged 2 mailing list files and have noticed there are a few duplicate records.Is there a way of de-duping in Excel?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
Excel - Mailing List | Excel Discussion (Misc queries) | |||
Mailing list in Excel | Excel Discussion (Misc queries) | |||
Use of Excel for Mailing List | Excel Discussion (Misc queries) |