Remove Duplicates in Single Column
Remove Duplicates in Excel
- Highlight/Select the Column A, similar to shown in below screenshot:
- Go To âDataâ tab on Menu Bar and click on âRemove Duplicatesâ as shown below:
-
Once you click on âRemove Duplicatesâ, it may show you below window. You need to select âContinue with the current selection
Note: If you do not see this window, please go to next step
- Then you will see below window, so you need to select the Column which may contain the duplicate data and click Ok.
Remember:
Select âMy data has headersâ option, if your data contains the header. So Client Name is header in my example. Refer to Cell âA1â
- Once you click Ok, it will remove the duplicates value. You may refer to my video to learn this trick and refer to next section to learn âHow to delete duplicates in Multiple Columnsâ
Download Practice File
You can also practice this through our practice files. Click on the below link to download the practice file.
