Want to dedupe a mailing list to remove duplicate
records? Excel can do for you, see the article from
Microsoft Knowledge Base.
How to Remove Duplicate Records or Create List of Unique RecordsThis article was previously published under Q262277
SUMMARYWhen Microsoft Excel imports or combines many records, it may create duplicates. This article describes how to create a compiled list of unique records.
MORE INFORMATIONTo create a compiled list of unique records, follow these steps:
If the first record of original data is duplicated, it appears twice in the new list. Just remove or delete the first line.
If you perform the Advanced Filter command in-place, the sheet still contains all records. Duplicate records are hidden. To work around this behavior, on the Data menu, point to Filter, and then click Show All.
The original text is found on this article: 262277 - XL: How to Remove Duplicate Records or Create List of Unique Records
Free consultation: Looking for software that NoClone can't fit, talk to us for customization and consultation.
©2003-2007 Reasonable Software House Ltd, All rights reserved. About Us | Contact us |
Download software at One Software Way | MailLib - newsletter archive and reader