Look Who it Was Random video

Excel - Removing Duplicates - Episode 415

407 views · Published 29 September 2009 · 1:50 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Easily Remove Duplicates in Excel.

Welcome back to the MrExcel netcast! With only 26 days left until the release of Excel 2007 on January 30th, 2007, I want to show you one of the exciting new features in this version. Today, on this 2007 Thursday, I'll be demonstrating how to easily remove duplicates in Excel 2007.

We all know the struggle of dealing with large lists or databases and trying to identify unique values in a specific column. Well, Excel 2007 has made this task much simpler. In this video, I have a list of invoices with dates, customers, and sales. I want to find out who the unique customers are in this list.

To do this, we will go to the Data ribbon and select the "Remove Duplicates" option. A new window will appear where we can choose which column to look for duplicates in. In this case, I'll select the "Customer" column and click OK. In just a few seconds, Excel has removed the 10 duplicate values, leaving us with only 9 unique customers.

However, I must warn you that this function is quite destructive. The duplicate rows are permanently deleted, so it's important to make a copy of your data set before using this feature. You can always use the "Undo" function (Ctrl+Z) to bring back the deleted rows, but it's always better to be safe than sorry. So, make it a habit to create a copy of your data set before using the "Remove Duplicates" feature.

Thanks for tuning in to this netcast from MrExcel! I hope this tip will help you save time and effort when dealing with large lists in Excel 2007. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you tomorrow for another netcast!

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) Introduction to Excel 2007 and unique values
(00:24) New trick in Excel 2007
(00:39) Easier way to find unique values in a large list or database
(00:50) Using the Remove Duplicates function on the Data ribbon
(01:09) Caution when using Remove Duplicates - make a copy of your data first
(01:31) 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 

This video answers these common search terms:
Conditional formatting to highlight duplicate values in Excel
Excel keep duplicates and delete everything else
Excel remove duplicates across columns
Excel remove duplicates with data intact
Filtering duplicate values in Excel
Formula to remove duplicates in Excel
How to remove duplicates in Excel without shifting
How to retrieve duplicates in Excel
Keeping duplicates and removing everything else in Excel
Removing duplicate rows in Excel
Undoing changes in Excel (Ctrl+Z, Alt+Backspace)
Using the UNIQUE function in Excel to remove duplicates

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152649/



Excel 2007 offers powerful new features for removing duplicates. Episode 415 shows how you can find the unique values in a list using just a couple of clicks.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

More from this channel