Say Goodbye to Duplicate Rows with Google Sheets Data Clean-up Menu

Are you tired of dealing with duplicate rows in your dataset? Well, worry no more! Google Sheets has a built-in feature that allows you to remove duplicates easily. No more manual searching and deleting rows one by one. Let me show you how to use the Data Clean-up Menu in Google Sheets to eliminate those pesky duplicates once and for all!

Removing Duplicates Made Easy

In the past, you might have used functions like UNIQUE or SORTN to get rid of duplicates. However, these functions have their limitations. They don’t alter the original data; instead, they provide the result in a new range. Furthermore, UNIQUE doesn’t support evaluating a key column or key row, making it less convenient for beginners. But fear not! The Remove Duplicates Data Clean-up Menu command is here to save the day!

Update: The Remove Duplicates feature has been moved to the Data > Data Clean-up menu.

How to Remove Duplicates Using Data Clean-up Menu in Google Sheets

Single Column (Unique Way)

Let’s start with removing duplicates in a single column.

1. Select the range of data you want to clean up.
2. Go to Data > Data Clean-up > Remove duplicates.
3. Check the “Data has a header row” option if your selection includes a header row.
4. Click the Remove duplicates button.

Alternatively, you can use a formula as an alternative to the Data Clean-up Menu command: =unique(A3:A11)

Multiple Columns (Unique Way)

Now let’s tackle removing duplicates in multiple columns.

1. Select the range of data that includes all the columns you want to clean up.
2. Go to Data > Data Clean-up > Remove duplicates.
3. Follow the on-screen prompts to specify any additional settings.

Once again, you can use a formula as an alternative: =unique(A1:B5)

Remove Duplicates in Selected Columns (Sortn Way)

What if you want to remove duplicates in selected columns?

1. Select the range of data that includes the columns you want to clean up.
2. Sort the data in ascending or descending order based on your preference.
3. Go to Data > Data Clean-up > Remove duplicates.
4. In the dialog box, select only the column(s) you want to use as the basis for removing duplicates.

You can also use the following formula as an alternative: =sortn(sort(A2:C7,1,1,2,1),9^9,2,1,1)

And there you have it! Removing duplicates in Google Sheets has never been easier. Whether you’re dealing with a single column or multiple columns, the Data Clean-up Menu command has got you covered. So say goodbye to duplicate rows and hello to a cleaner and more organized dataset!

For more expert tips and tricks on using Google Sheets, head over to Crawlan.com. We’ve got all the information you need to become a Sheets pro.