Quickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results.
This add-on comes with two useful wizards. One will show how to delete duplicates in Google Sheets in 4 steps, the other will quickly compare data from two columns for repeated values.
"Find duplicates or uniques" is a quick assistant for Google Sheets: remove duplicates in a column or find duplicate rows. You are free to include the first occurrences or look for unique entries. It lets you choose one of 6 ways you can deal with the results: highlight or remove duplicate lines, copy or move them to another Google Spreadsheet, or clear duplicate entries leaving the cells intact. Once you run the add-on, it will display a summary for the results found in your sheet.
Use the "Compare columns or sheets" tool to quickly scan two Google Sheets columns for the same values. It will take you five simple steps to compare lists and mark the results with colour or status, copy or move them, clear repeating cells, or remove duplicate rows from your main table.
The add-on offers case-sensitive search and additional options for handling empty cells and headers. You can use this tool to make your Google Sheets duplicate-free in a flash.
Version 1.2: Take advantage of all Pro features for free: mark duplicate values in a separate column, copy or move the found rows to another sheet.
Version 1.6: We fixed the issues you reported and made the add-on much faster!
Feel free to try it out on this test spreadsheet:
If you have any questions about deleting duplicates in Google Sheets, please post them in our community: http://goo.gl/5aqwsD