Find Duplicates in Google Sheets Using the Remove Duplicates Tool
Google Sheets includes a built-in tool that will search the sheet based on the criteria you provide.
Find Duplicates in Google Sheets Using the UNIQUE Function
The UNIQUE function in Google Sheets returns unique rows from the provided source range, discarding duplicates. The UNIQUE function returns rows in the order they first appear in the source range. Using this method, you are able to view and compare both sets of data before deleting the original duplicates.
Find and Remove Duplicates in Google Sheets Using an Add-on
Add-ons are tools created by third-party developers that improve or simplify your experience using Google Sheets. Add-ons are available that will find and remove duplicates from your spreadsheet in Google Sheets. While no two add-ons are identical, many include similar features. Learn how to locate add-ons that find and remove duplicates in Google Sheets and how to decide which one best suits your needs.
