Register now or log in to join your professional community.
Through data tab we can remove the duplicate values in Excel Sheet.
Filtering for unique values and removing duplicate values are two closely related tasks because the displayed results are the same — a list of unique values. The difference, however, is important: When you filter for unique values, you temporarily hide duplicate values, but when you remove duplicate values, you permanently delete duplicate values.
A duplicate value is one where all values in the row are an exact match of all the values in another row. Duplicate values are determined by the value displayed in the cell and not necessarily the value stored in the cell. For example, if you have the same date value in different cells, one formatted as "3/8/2006" and the other as "Mar8,2006", the values are unique.
It's a good idea to filter for or conditionally format unique values first to confirm that the results are what you want before removing duplicate values.
1. Open your database in Excel and select the sheet you want to work with.
2. Select the data that you want to check for duplicates.
3. Click on the "Data" tab in the top horizontal toolbar.
4. Click "Advanced Filter" in the drop down menu. It is under a group name "Sort & Filter"
5. Check the box that says "Unique Records Only" This will hide duplicate values, allowing the copied list to be free of duplicates.
6. Specify the area of the sheet where you want your copied filtered cells to be taken to. You can also save the list in the same place. The duplicate values will only be hidden and not deleted from a new copied list.
7. Save the list under a new name to delete the duplicates completely.
1. Open your database in Excel2010 or later. Select the sheet you want to work with.
2. Save the database under a new name. This will allow you to ensure you have the original copy in case some needed data is deleted.
3. Click on the "Data" tab.
4. Select the columns or rows that you want to check for duplicates
5. Click the "Remove duplicates" button in the data toolbar.
6. Find how many duplicates are in your selected cells. Click the "Remove Duplicates" button at the bottom, if the program has found duplicate as well as unique values.
7. Save your new copy again to ensure only unique values will remain.
Follow the below link for removing duplicate valued in excel sheet. Its illustrated and comprehensive detail.
http://www.wikihow.com/Remove-Duplicates-in-Excel
It can also be done using Pivot table option..
select data > go to data tab > click remove the duplicate values in Excel Sheet .
choose columns you want to remove duplicate in > press ok
To remove duplicates value or records from excel, you can use duplicates remove tool of excel. You can also use deduplication software for it which can help to remove duplicates very easily. You can download it from http://www.deduplicationsoftware.com/download-clean-and-match-2013.html .
If you want to remove all kind of duplicate items that can increase the Outlook file size, then you can use manual technique for removing duplicate items in PST files. Both technical and no technical user easily use the manual steps and it does't require any third party tool.
User can get more information about manual steps, here:- http://migrateemails.com/2016/06/13/remove-outlook-duplicates/
