Hello everyone, and welcome to our Microsoft Excel tutorial series
In this video, you will learn to find and remove duplicate values from a series of data
Duplicate value is one where all values of a particular row are an exact match of all the values in some other row
Do remember that duplicate values are determined by the value displayed in the cell, not by the values stored in the cell
For instance, if you take a look at both details, you will find that the values in both cells are similar, but both formats of both are unique
Be sure about the results before you remove the duplicate values, or you can run social or conditional formatting before removing the duplicate values
It is a good idea to copy your data to another sheet before removing duplicate values, so if something goes wrong, then you may still have a chance to reverse back
To remove duplicate values, select the rows of cells. On the Data bar, click Remove Duplicate
Under Data Tools group, you will be asked to select the columns that contain duplicate values
You must select the columns carefully, as Excel is asking you to which rows it should consider as duplicate
For instance, if I only select Order Date, Reason, and Sales Person, and uncheck all the other columns
then all the rows, whom have similar values in these three columns alone will be removed, even though if the item, unit, cost and total were different
As I mentioned earlier, mostly you consider those rows as duplicate, which are an exact copy of values from other rows, including all the headings
You can easily uncheck all headings by clicking and select All button, or can check every item by clicking Select All
My data has header as checked by default, and Excel assumes that the first row in the selected cell range have headings, which it will display in the columns list
If you uncheck this option, then headings from columns will vanish, and Excel will start displaying the columns by their actual headings, and will consider first row as a duplicate value
Clicking OK will instantly find and remove the duplicate values from the selected range
and will display a message that how many duplicate values were removed, and how many unique values remain
If there were no duplicate values, then Excel will display a corresponding message
Press OK to complete the task. So, that is all about removing duplicate values
If you like this video, then don't forget to hit thumbs up, and do subscribe to our channel for more upcoming videos
Till then, have a nice day, and take good care of yourself