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.



    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                  Zoho SalesIQ Resources



                      Zoho TeamInbox Resources




                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW


                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now











                                                          • Related Articles

                                                          • 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 ...
                                                          • Create pivot tables to analyse your data

                                                            Create a pivot table in sheet To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created Drag and drop the fields into the desired positions in the Pivot ...
                                                          • Create and customize charts to visualize data

                                                            Create a chart To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, ...
                                                          • Sort a data range

                                                            To sort a cell range: Select the cell range to sort, keeping the column to sort by as the first column. Go to  icon Under the Data menu, choose Sort. Tap on Ascending or Descending based on how you wish to sort the data.
                                                          • How to create data validation?

                                                            Create a data validation for cells To create data validation: Click Data > Data Validation. You can choose the required range to apply data validation from the dialog shown below. The options that are available include the following: Decimal number, ...

                                                          Resources

                                                          Videos

                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                          eBooks

                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                          Webinars

                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.



                                                            Zoho Show Resources