How to Remove Duplicates in Google Sheets: A Step-by-Step Guide


Google Sheets is a great spreadsheet application for creating and editing files online while collaborating with others in real time. Google Sheets offers a range of features, including editor-specific colors and revision history. Additionally, the application is compatible with Microsoft Excel. Here, we will look at three methods, with simple and easy steps to remove duplicates. google sheets,

How to remove duplicates in Google Sheets using the De-duplicate tool

Step 1: Select the dataset from which you want to remove duplicates.

Step 2: Go to statistics option in the menu and click data cleansing and then click Remove duplicates.

Step 3: In remove duplicates dialog box, select data contains header row If you have a header row in your data.


Step 4: Under column to analyze Select the columns you want to analyze. If you select only one column, duplicates will be removed based on the data in that column only.

Step 5: Click on remove duplicates button.

Step 6: At the prompt, click Ok.

If you want to delete data from only one column, select the data in that column and follow the above steps. Duplicate data will be removed without disturbing the data in other columns.

How to Remove Duplicates in Google Sheets Using the UNIQUE Function

Step 1: Write ‘=Unique(Column:Row)’ in any cell where you want your output. Replace ‘Column’ with the first-row value of the dataset and replace ‘Row’ with the last-row value of the dataset you want to analyze, as shown in the picture below.

Step 2: Hit Enter, and you have your cleaned data set.

Please note that the function will only consider content as duplicates where an entire row of content is repeated. Also, if your data contains extra spaces or leading or trailing spaces, the function will treat them as separate.

How to Remove Duplicates in Google Sheets Using Conditional Formatting

Step 1: Select the range of data from where you want to remove duplicates. Leave out the header column when selecting.

Step 2: Go to Format And then conditional formatting.

Step 3: In conditional format rules window, go to format rules and select from the dropdown custom formula.

Step 4: Input the formula =(COUNTIF($A$1:$A,$A1)>1)*(COUNTIF($B$1:$B,$B1)>1) and click Complete,

Duplicates in your data will be highlighted. You can change the highlight color on the Conditional Format menu. Also, you can remove duplicate value by using Backspace or Delete Row option.

The post How to Remove Duplicates in Google Sheets: A Step-by-Step Guide appeared first on Techlusive.

Read full article here

Leave a Reply