Google Sheets: Remove Duplicate Rows Based on One Column


Often you may want to remove duplicate rows based on values in one column in Google Sheets.

The easiest way to do this is by using the Remove Duplicates feature under the Data tab.

The following example shows how to do so in practice.

Example: Remove Duplicate Rows Based on One Column in Google Sheets

Suppose we have the following dataset in Google Sheets that contains information about various basketball players:

Notice that there are several duplicate values in the Team column.

Suppose we would like to remove all rows with duplicate values in the Team column.

To do so, highlight the cell range A2:B12. Then click the Data tab, then click Data cleanup, then click Remove duplicates:

Google Sheets remove duplicate rows based on one column

In the new window that appears, only check the box next to Column A under Columns to analyze:

Once you click Remove duplicates, all of the rows with duplicate values in the Team column will be removed:

Notice that all of the rows with duplicate values in the Team column have been removed.

In total, 7 rows with duplicate values in the Team column were removed and only the 4 rows with unique values in the Team column were kept.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Find Duplicates in Two Columns
Google Sheets: How to Count Duplicates
Google Sheets Query: How to Return Only Unique Rows

Leave a Reply

Your email address will not be published. Required fields are marked *