Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How we can remove duplicate value from an Excel Sheet?

user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/12/09
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Through data tab we can remove the duplicate values in Excel Sheet.

Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Project Controller , Hayat Communication (www.haytacommunications.com)

values or removing duplicate values

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.

Muhammad Zeeshan Sarwar
by Muhammad Zeeshan Sarwar , Financial Controller , Arveen General Trading LLC

Method1: Remove Duplicates Manually

 

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.

 

Method2: Use the Duplicate Manager

 

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.

 

 

Ragnar Ragnarsson
by Ragnar Ragnarsson , Credit Controller - Lead Internal auditor - Quality Assurance Coordinator , DHL Express
Muhammad Atif Nawaz
by Muhammad Atif Nawaz , Production Planner Precast , Redco International wll

Follow the below link for removing duplicate valued in excel sheet. Its illustrated and comprehensive detail.

 

http://www.wikihow.com/Remove-Duplicates-in-Excel

MASOOQUE ALI
by MASOOQUE ALI , PAYROLL OFFICER , Arabian Bemco Contracting Co. Ltd

It can also be done using Pivot table option..

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

 

 select data  > go to  data tab  >  click  remove the duplicate values in Excel Sheet .

choose columns you want to remove duplicate in > press ok 

Stephine Lisa
by Stephine Lisa , Software , Software

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/

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.