Excel - How To Remove Duplicates In Excel And Keep One - Episode 1433
2,382 views · Published 22 September 2011 · 1:31 · Indexed 26 October 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Learn how to remove duplicates in Excel - Quick and Easy Solution! Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing how to remove duplicates in Excel. This is a common issue that many Excel users face, and today we will be showing you a simple solution to this problem. Recently, I received a question from John, who has attended one of my seminars before. He has a large dataset of 169,000 rows and is struggling with finding duplicate records in one of the columns. He was looking for a VBA solution to remove these duplicates, but I told him that he doesn't need any VBA at all. The solution to this problem is actually quite simple. First, I confirmed that John was using Excel 2007, as he had a large dataset. This means that he can easily use the "Remove Duplicates" feature under the Data tab. By default, this feature is set to look at all fields, but in this case, we only want to look at one specific column. So, we simply unselect all fields and then re-select the column we want to focus on. With just a few clicks, we were able to remove 77 duplicate values and keep 99 unique values. You might be thinking that this sounds too good to be true, but thanks to Microsoft and Excel 2007, the "Remove Duplicates" feature is a fast and efficient way to solve this problem. No need for complicated VBA code or manual sorting. So, next time you encounter duplicate records in your Excel data, remember this simple solution. Thanks for tuning in to this episode of the MrExcel podcast, and we'll see you next time for more Excel tips and tricks. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Removing Duplicates (00:14) Issue with Duplicate Records (00:24) Solution: Using Excel's "Remove Duplicates" Feature (00:45) Step-by-Step Instructions (01:01) Results (01:11) Excel's Efficiency (01:21) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelremoveduplicates This video answers these common search terms: remove duplicate numbers in a column in excel how remove duplicate rows in excel can i remove duplicates in excel how to remove duplicate entries in excel how to remove duplicates in data set excel how to remove duplicates in excel and keep one how to remove duplicates on excel spreadsheet how do i remove duplicates in an excel spreadsheet how to quickly remove duplicates excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153111/ John is looking for some VBA to find and remove duplicate records in a database of 169,000 records. Today, in Episode #1433, Bill shows us how its done.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920