How to Remove Duplicates in Google Sheets

Created with Trainn AI

Here's a step-by-step walkthrough on how to remove duplicates in Google Sheets

1. Select the first cell you want to start tracking the duplicates on and right-click on it to open the options menu.

Screenshot of how to remove duplicates in Google Sheet step 1

2. In the options menu, click on "View more cell actions" at the bottom.

Screenshot of how to remove duplicates in Google Sheet step 2

3. From the expanded menu, select "Conditional formatting."

Screenshot of how to remove duplicates in Google Sheet step 3

4. In the sidebar, under the "Apply to range" field, enter the value "colon, A1000" next to "A2".

You can replace "A" with the actual letter of the column of your selected cell.

Screenshot of how to remove duplicates in Google Sheet step 4

5. Then, select the dropdown menu under "Format rules".

Screenshot of how to remove duplicates in Google Sheet step 5

6. Scroll down the dropdown menu and select "Custom formula is".

Screenshot of how to remove duplicates in Google Sheet step 6

7. In the formula box, type this formula: =COUNTIF($B$2:$B$149,A2)>0.

You can replace the letters and numbers according to the cells in your Google Sheet.

Screenshot of how to remove duplicates in Google Sheet step 7

8. Then, click the "Done" button.

Screenshot of how to remove duplicates in Google Sheet step 8

9. The duplicates are now highlighted.

Screenshot of how to remove duplicates in Google Sheet step 9

10. Now, select the column with the duplicates highlighted.

Screenshot of how to remove duplicates in Google Sheet step 10

11. Select the "Create a filter" option from the toolbar.

Screenshot of how to remove duplicates in Google Sheet step 11

12. Click on the filter icon next to the first cell of the column.

Screenshot of how to remove duplicates in Google Sheet step 12

13. Choose "Filter by color" from the dropdown menu.

Screenshot of how to remove duplicates in Google Sheet step 13

14. Then select "Fill Color".

Screenshot of how to remove duplicates in Google Sheet step 14

15. Then select the highlight color.

Screenshot of how to remove duplicates in Google Sheet step 15

16. Now with only the duplicates available, select all of them and hit backspace to delete them.

Screenshot of how to remove duplicates in Google Sheet step 16

17. In the toolbar, click on the "Remove filter" button.

Screenshot of how to remove duplicates in Google Sheet step 17

18. Observe that the duplicates are now removed.

Screenshot of how to remove duplicates in Google Sheet step 18

Congrats! You have successfully removed duplicates from Google Sheets!