Remove Duplicates in a flash
Removing duplicates used to involve a few steps and worksheet functions. This page will show you the old method. With the introduction of Excel 2007, Microsoft has introduced a new function called "Remove Duplicates" which simplifies the whole process.
Let's supposed you have a list of data with multiple columns. To use function, you need to identify the column(s) which contains the duplicates. Then select the whole range, go to the data tab, find the "Remove Duplicate" icon. It is located in
the right half of the ribbon, within the Data Tools group. Click on the icon, uncheck the columns that are not causing the duplicate records. Click OK and the function will remove all the duplicated rows. If you are more of a visual guy, watch the video below.
New! CommentsHave your say about what you just read! Leave me a comment in the box below.
Share this page:
Enjoy this page? Please pay it forward. Here's how...
Would you prefer to share this page with others by linking to it?
- Click on the HTML link code below.
- Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft