NoClone

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 Records

This article was previously published under Q262277

SUMMARY

When Microsoft Excel imports or combines many records, it may create duplicates. This article describes how to create a compiled list of unique records.

MORE INFORMATION

To create a compiled list of unique records, follow these steps:

Select the column titles above rows or records that you want to sort.
On the Data menu, point to Filter, and then click Advanced Filter. If you are prompted as follows, click OK.
No headers detected. Assume top row of selection is header row?
Under Action, click Copy to another location.
Click to select the Unique records only check box.
In the List range box, type or select the range of records (such as A3:H10).
In the Criteria range box, type or select the same range of records (that is, A3:H10)
In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don't overwrite pre-existing data.

NOTE: You can only do this in the active sheet.
Click OK.

NOTES:

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.

|Français |Deutsch |Czech |

Join NoClone mailing list now It provides a full tutorial on getting started & offers some useful techniques, plus details of our SPECIAL OFFERS. Your email will NOT be disclosed to third parties.

Add other subscriptions/Unsubscribe Past Newsletters Reasonable Spread: Permission email marketing