J Jonathan6315 Apr 29, 2010 #1 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??
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??
E Eduardo Apr 29, 2010 #2 Hi, Look CPearson web, go to the middle of the page where it says delete duplicate rows http://www.cpearson.com/excel/deleting.htm
Hi, Look CPearson web, go to the middle of the page where it says delete duplicate rows http://www.cpearson.com/excel/deleting.htm
J Jacob Skaria Apr 29, 2010 #3 Check out this option. --Select data range and from menu Data>Filter>Advanced Filter>Copy to another location.. --In 'copy to' select a cell and check 'Unique records only' --Click OK ..will give you the unique list
Check out this option. --Select data range and from menu Data>Filter>Advanced Filter>Copy to another location.. --In 'copy to' select a cell and check 'Unique records only' --Click OK ..will give you the unique list
T Tom Hutchins Apr 29, 2010 #4 If you are using Excel 2007 you can use the 'Remove Duplicates' button on the Data ribbon. Hope this helps, Hutch
If you are using Excel 2007 you can use the 'Remove Duplicates' button on the Data ribbon. Hope this helps, Hutch
