How to Remove Duplicates in Google Sheets

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.

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

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

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.

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

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

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.

8. Then, click the "Done" button.

9. The duplicates are now highlighted.

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

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

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

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

14. Then select "Fill Color".

15. Then select the highlight color.

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

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

18. Observe that the duplicates are now removed.

Congrats! You have successfully removed duplicates from Google Sheets!