Remove data duplicates

Remove data duplicates

    1. Select the range of cells from which you want to detect the duplicates 

    2. Click the Data menu.

    3. From the menu, select Data Cleaning .

    4. Click on Find Duplicates

    5. The Data cleaning tool will let you know the number of duplicate and unique values in the selected data.

    6.  Choose the desired options, before selecting the action to be performed, i.e. delete, highlight, move or copy the duplicates.

    • Related Articles

    • Import Data

      Importing records into your Recruit account can help you create new candidates from data gathered through various sources, such as a purchased record database or records from different business units. You can import records using two features: Import ...
    • How to find and remove duplicate records in my Form

      It is possible to find the duplicate entries in the database and delete them. Below is the example of removing duplicate email entries in your database. You can replace the Email field with the field name that you want to find for duplicate entries. ...
    • How do I remove sample data from Zoho CRM?

      To remove sample data from your CRM account, do the following: Go to Setup  > Data Administration > Remove Sample Data. Click Yes, Proceed. The sample data removal process will be scheduled. You will be notified once the sample data has been ...
    • Importing Data to Zoho CRM

      Data can be gathered through various sources such as, purchasing a record database, collecting from trade shows and campaigns, and so on. Importing records from such external sources to Zoho CRM is one of the most important lead creation activities ...
    • Find and remove data inconsistencies

      1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...