Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to remove duplicate records or create list of unique records in Excel
Article ID: 262277 - View products that this article applies to.
This article was previously published under Q262277
When Microsoft Excel imports or combines many records, it may create duplicates. This article describes how to create a compiled list of unique records.
To 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 hide 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, point to Rows on the Format menu, and then click Unhide.
Article ID: 262277 - Last Review: January 27, 2007 - Revision: 4.3